diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-10-14 00:12:44 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-10-14 00:12:44 +0000 |
| commit | 1f238e569acbc2a41be497d4fe1b1b797e5ae902 (patch) | |
| tree | f45da2fcad39a305d785b9dafce639bc1c3f2a69 /doc/src | |
| parent | e3b0117459fd24b15cb5e88f563b5d87f051cfdc (diff) | |
Eliminate unnecessary array[] decoration in examples of recursive cycle
detection.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/queries.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
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 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.48 2008/10/13 16:25:19 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.49 2008/10/14 00:12:44 tgl Exp $ --> <chapter id="queries"> <title>Queries</title> @@ -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 |