[SQL] WITH RECURSION output ordering with trees

Hi, I'm playing with the new WITH RECURSIVE feature of 8.4. I'm trying to figure out how to use it with trees. Here is the test code I use: - --DROP TABLE recursion; CREATE TABLE recursion ( id serial, lookup varchar(16), parent_id

Re: [SQL] WITH RECURSION output ordering with trees

pgsql-sql-ow...@postgresql.org wrote: Hi, I'm playing with the new WITH RECURSIVE feature of 8.4. I'm trying to figure out how to use it with trees. Here is the test code I use: - --DROP TABLE recursion; CREATE TABLE recursion

Re: [SQL] WITH RECURSION output ordering with trees

Philippe Lang, 10.07.2009 11:10: Hi, I'm playing with the new WITH RECURSIVE feature of 8.4. I'm trying to figure out how to use it with trees. Here is the test code I use: I'd like to perform a real recursion, and show the tree structure in a more appopriate way, like this: Any idea how to

Re: [SQL] WITH RECURSION output ordering with trees

pgsql-sql-ow...@postgresql.org wrote: Philippe Lang, 10.07.2009 11:10: Hi, I'm playing with the new WITH RECURSIVE feature of 8.4. I'm trying to figure out how to use it with trees. Here is the test code I use: I'd like to perform a real recursion, and show the tree structure in a

Re: [SQL] WITH RECURSION output ordering with trees

In article e6a0649f1fbfa3408a37f505400e7ac215c...@email.attiksystem.ch, Philippe Lang philippe.l...@attiksystem.ch writes: Thanks for your answer. Si there a built-in function that would allow generating the sort path based on the value of the lookup column, instead of the id, which has no

Re: [SQL] WITH RECURSION output ordering with trees

pgsql-sql-ow...@postgresql.org wrote: In article e6a0649f1fbfa3408a37f505400e7ac215c...@email.attiksystem.ch, Philippe Lang philippe.l...@attiksystem.ch writes: Thanks for your answer. Si there a built-in function that would allow generating the sort path based on the value of the lookup