Svenne Krap <svenne.lists@krap.dk> 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 second "with recursive". WITH introduces a list of
name-AS-subselect clauses, not just one.
regards, tom lane