On 02-05-2011 00:12, Tom Lane wrote:
> Leave out the second "with recursive". WITH introduces a list of
> name-AS-subselect clauses, not just one.
>
Thanks :)
Svenne
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
Svenne Krap writes:
> The two recursive parts seems to do the right thing each on its own, but
> together i get an error...
> with recursive downpath as (
> [ something ]
> ),
> with recursive uppath as (
> [ something ]
> )
> select ...
Leave out the
Hi.
I just tried to make a query that traverses a tree upwards to locate the
root and then downwards to locate all branches on PGSQL 9.0.
The two recursive parts seems to do the right thing each on its own, but
together i get an error...
ERROR: syntax error at or near "with recursive"
LINE 6:
