|
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. |
