From 1f238e569acbc2a41be497d4fe1b1b797e5ae902 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 14 Oct 2008 00:12:44 +0000 Subject: Eliminate unnecessary array[] decoration in examples of recursive cycle detection. --- doc/src/sgml/queries.sgml | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 0232d80db71..ef9383a2f71 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1,4 +1,4 @@ - + Queries @@ -1639,7 +1639,7 @@ WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS ( FROM graph g UNION ALL SELECT g.id, g.link, g.data, sg.depth + 1, - path || ARRAY[g.id], + path || g.id, g.id = ANY(path) FROM graph g, search_graph sg WHERE g.id = sg.link AND NOT cycle @@ -1664,7 +1664,7 @@ WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS ( FROM graph g UNION ALL SELECT g.id, g.link, g.data, sg.depth + 1, - path || ARRAY[ROW(g.f1, g.f2)], + path || ROW(g.f1, g.f2), ROW(g.f1, g.f2) = ANY(path) FROM graph g, search_graph sg WHERE g.id = sg.link AND NOT cycle -- cgit v1.2.3