Postgres Pro
Downloads
Home   >   mailing lists

How to use recursive clause in one with query - Mailing list pgsql-general

From Andrus
Subject How to use recursive clause in one with query
Date
Msg-id 768C1760D2C44B2DB58B96AE2262066C@dell2
Whole thread Raw
Responses Re: How to use recursive clause in one with query  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
How to use one recursive query if there are may queries in WITH statement ?
 
I tried
 
with
a as ( select 1 as col1 ),
RECURSIVE t(n) AS (
    VALUES (1)
  UNION ALL
    SELECT n+1 FROM t WHERE n < 100
),
c as (select * from t)
  select * from c
 
but got error
 
syntax error at or near "t"
 
at line  
 
RECURSIVE t(n) AS (
 
recursive b as ( shown in comment
 
with clause is used to create some non recursive queries (a) .
After them recursive query is defined (b) and after it there are some other non-recursive queries (c)
 
Using Postgres 9.1 and above.
 
Andrus.

pgsql-general by date:

Previous
From: Tim Smith
Date:
Subject: A question for Postgres OLAP gurus ....
Next
From: David G Johnston
Date:
Subject: Re: How to use recursive clause in one with query