Folks,
I tried the following and it broke:
WITH RECURSIVE t(j) AS ( WITH RECURSIVE s(i) AS ( VALUES (1) UNION ALL SELECT i+1 FROM s WHERE i < 10
)SELECT i AS j FROM s
UNION ALL SELECT j+1 FROM t WHERE j < 10
)
SELECT * FROM t;
ERROR: relation "s" does not exist
LINE 6: ) SELECT i AS j FROM s ^
Shouldn't this work?
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate