Re: Multiple recursive part possible?

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