Add docs and regression test about sorting the output of a recursive query in

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 06224652f23441588b9d50cab7311e2c6ec05414
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2008-10-14T00:41:35Z
Releases: 8.4.0
Add docs and regression test about sorting the output of a recursive query in
depth-first search order.  Upon close reading of SQL:2008, it seems that the
spec's SEARCH DEPTH FIRST and SEARCH BREADTH FIRST options do not actually
guarantee any particular result order: what they do is provide a constructed
column that the user can then sort on in the outer query.  So this is actually
just as much functionality ...

Files

PathChange+/−
doc/src/sgml/queries.sgml modified +13 −2
src/test/regress/expected/with.out modified +38 −0
src/test/regress/sql/with.sql modified +10 −0