Team,
This was strange. I wanted to set up a CTE that would FEED my recursive query.
And also feed the results filtering...
These are the most trivial examples. The second one results in a syntax error. Which implies that:
1) There can only be one recursive CTE at the same level?
2) It must be the FIRST CTE?
1) There can only be one recursive CTE at the same level?
2) It must be the FIRST CTE?
Example:
WITH RECURSIVE CTE1 AS (select 2 UNION ALL SELECT 0),
CTE2 AS (select 1 UNION ALL SELECT 0) select 3 ;
-- This does not work:
WITH CTE1 AS (select 2 UNION ALL SELECT 0),
RECURSIVE CTE2 AS (select 1 UNION ALL SELECT 0)
SELECT 3;
CTE2 AS (select 1 UNION ALL SELECT 0) select 3 ;
-- This does not work:
WITH CTE1 AS (select 2 UNION ALL SELECT 0),
RECURSIVE CTE2 AS (select 1 UNION ALL SELECT 0)
SELECT 3;
--> ERROR: syntax error at or near "CTE2"
Thanks in advance...
Kirk
Kirk