Nicolas Modrzyk wrote:
> Hi All,
>
> Could anyone let us know how to understand the attached query ?
> From what I know this is an Orion (java application server) generated
> query for postgresql...
>
> The C-JDBC parsing seems to fail because we can't find a proper FROM
> keyword to select the depedencies of the query.
> Since this is not seemingly SQL92 standard, can anyone from the
> postgresql team give us some information ?
I am confused. Are you encountering a C-JDBC problem, a PostgreSQL JDBC
driver problem, a PostgreSQL backend query parsing problem, or something
else again? Exactly what error or misbehaviour do you see?
The query itself does not seem too painful, it is a CREATE TABLE AS with
a query part that has lots of UNIONs:
CREATE TABLE ... AS
SELECT ... FROM ...
UNION
SELECT ... FROM ...
UNION
SELECT ... FROM ...
[...]
-O