Hi Eric, Thanks for the info. Yes, in order to guarantee that jOOQ works with PostgreSQL 8.x, there's nothing but running integration tests. I'll try this on my side eventually. If various versions of PostgreSQL can be run in parallel, there's no stopping jOOQ from supporting older versions, given that they're still in wide use with Amazon Redshift - which is indeed PostgreSQL 8.0.2 (!), according to this documentation:
http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html Regarding the optional / not-optional "as" keyword, are you sure, "as" is not rendered by jOOQ? It should be, for PostgreSQL: https://github.com/jOOQ/jOOQ/blob/d0a9d76a05cdf9e3abe20c0d062b9395b9e6b685/jOOQ/src/main/java/org/jooq/impl/Alias.java#L201 Cheers Lukas 2013/9/19 Eric Schwarzenbach <[email protected]> > 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. > -- 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.
