When I'm running query below I get message:
[Amazon](500310) Invalid operation: WITH RECURSIVE is not supported;
Can someone explain me why recursive function doesn't work? (I'm working on amazon redshift)
WITH RECURSIVE r AS (
SELECT
1 AS i,
1 AS factorial
UNION
SELECT
i+1 AS i,
factorial * (i+1) as factorial
FROM r
WHERE i < 10
)
SELECT * FROM r;
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…