Commit1f238e5

committed

Eliminate unnecessary array[] decoration in examples of recursive cycle

detection.

1 parente3b0117 commit1f238e5Copy full SHA for 1f238e5

File tree

-5

lines changed

-5

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.48 2008/10/13 16:25:19 tgl Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.49 2008/10/14 00:12:44 tgl Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="queries">`
`4`	`4`	`<title>Queries</title>`
`@@ -1639,7 +1639,7 @@ WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS (`
`1639`	`1639`	`FROM graph g`
`1640`	`1640`	`UNION ALL`
`1641`	`1641`	`SELECT g.id, g.link, g.data, sg.depth + 1,`
`1642`		`- path \|\|ARRAY[g.id],`
	`1642`	`+ path \|\| g.id,`
`1643`	`1643`	`g.id = ANY(path)`
`1644`	`1644`	`FROM graph g, search_graph sg`
`1645`	`1645`	`WHERE g.id = sg.link AND NOT cycle`
`@@ -1664,7 +1664,7 @@ WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS (`
`1664`	`1664`	`FROM graph g`
`1665`	`1665`	`UNION ALL`
`1666`	`1666`	`SELECT g.id, g.link, g.data, sg.depth + 1,`
`1667`		`- path \|\|ARRAY[ROW(g.f1, g.f2)],`
	`1667`	`+ path \|\| ROW(g.f1, g.f2),`
`1668`	`1668`	`ROW(g.f1, g.f2) = ANY(path)`
`1669`	`1669`	`FROM graph g, search_graph sg`
`1670`	`1670`	`WHERE g.id = sg.link AND NOT cycle`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -465,7 +465,7 @@ insert into graph values`
`465`	`465`	`with recursive search_graph(f, t, label, path, cycle) as (`
`466`	`466`	`select *, array[row(g.f, g.t)], false from graph g`
`467`	`467`	`union all`
`468`		`-select g.*, path \|\|array[row(g.f, g.t)], row(g.f, g.t) = any(path)`
	`468`	`+select g.*, path \|\| row(g.f, g.t), row(g.f, g.t) = any(path)`
`469`	`469`	`from graph g, search_graph sg`
`470`	`470`	`where g.f = sg.t and not cycle`
`471`	`471`	`)`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -266,7 +266,7 @@ insert into graph values`
`266`	`266`	`with recursive search_graph(f, t, label,path, cycle)as (`
`267`	`267`	`select*, array[row(g.f,g.t)], falsefrom graph g`
`268`	`268`	`union all`
`269`		`-select g.*,path\|\|array[row(g.f,g.t)], row(g.f,g.t)= any(path)`
	`269`	`+select g.*,path\|\| row(g.f,g.t), row(g.f,g.t)= any(path)`
`270`	`270`	`from graph g, search_graph sg`
`271`	`271`	`whereg.f=sg.tand not cycle`
`272`	`272`	`)`

Comments

(0)