Hello Sander > 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?
I've had another look at this. If you're daring enough, you can generate the Postgres pg_catalog schema, in fact. This schema contains all built-in functions from Postgres. I'm already doing this, partially for jooq-meta, as I need Postgres' pg_catalog.format_type function: https://github.com/lukaseder/jOOQ/blob/master/jOOQ-meta/src/main/java/org/jooq/util/postgres/pg_catalog/Routines.java Since there are about 2000 functions in pg_catalog, I guess it won't make sense for me to deliver them all in a standard build. Cheers Lukas
