Hi all
According to the documentation for the WITH clause, "the recursive table
must appear exactly once in the FROM clause of the recursive-select and must
not appear anywhere else in either the initial-select or the
recursive-select, including subqueries".
I am trying to do the following -
WITH RECURSIVE temp AS (
[initial-select UNION ALL recursive-select]
)
SELECT * FROM temp UNION * FROM temp
Obviously this is a simplification, but you get the idea.
I get the error 'no such table: temp'.
This query works with SQL Server and with PostgreSQL.
Is this a limitation of sqlite3, or is there any workaround?
Thanks
Frank Millman
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
