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
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
but got error