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?
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;
--> ERROR: syntax error at or near "CTE2"
Thanks in advance...
Kirk