Just as a FYI tidbit: I've run JOOQ code on a PostgreSQL 8.4 server with no problems. Of course that code didn't excercise all the possible syntax.
However running on an server running PostgreSQL 8.3.1 I did recently encounter a syntax issue. The sql generated was select "testTypes"."id" "foo" from "app"."testTypes" which produces and error like ERROR: syntax error at or near ""foo"" This version of PostgreSQL wants an AS for the column aliasing: select "testTypes"."id" as "foo" from "app"."testTypes" would work. Again this is just an FYI. I've simply switched this work to a more up to date server. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
