Andrus Moor wrote
> 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
>
> bu
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
