Re: Multiple recursive part possible? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Multiple recursive part possible?
Date
Msg-id 26285.1304287949@sss.pgh.pa.us
Whole thread Raw
In response to Multiple recursive part possible?  (Svenne Krap <svenne.lists@krap.dk>)
Responses Re: Multiple recursive part possible?  (Svenne Krap <svenne.lists@krap.dk>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Svenne Krap
Date:
Subject: Multiple recursive part possible?
Next
From: Svenne Krap
Date:
Subject: Re: Multiple recursive part possible?