Hi Lukas, Today i was trying to use the "md5" function in PostgreSQL and found out that this one is not supported by jOOQ. It looks like there are quite a few "built in" functions that are not supported. In fact, it's easier to use advanced functions from postgres "extensions" like pgcrypto (because they get generated as "routines" by jooq-codegen) than it is to use some of the simple Postgres-specific builtin functions. Would it be possible to get code generated for these built- in functions as if they were user-defined functions?
Also, PostgreSQL supports functions that return a table (see the "RETURNS TABLE" stuff at http://www.postgresql.org/docs/9.1/static/sql-createfunction.html ) . Is there any chance jOOQ could support this too? Sander
