Re: Multiple recursive part possible?

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