On Fri, Dec 4, 2020 at 1:57 AM Rob Sargent <[email protected]> wrote:
> I failed thrice at sending this from the google forum. That editor is > beyond painful. > You can send mails to the list with any email client, to [email protected] > Using jOOQ 3.14, java 15 and Postgres (12) > > Postgres overloads substring to work on bytea data, so against [...] > We don't support that function. There are probably a lot of bytea overloads in PostgreSQL that are a bit weird but can be seen to make sense, like this substring() function. A bytea isn't really a string, but I can see how some PostgreSQL developer thought this was a good thing to do... :) You can generate the pg_catalog schema and access this function as an ordinary stored function. Or, you can use plain SQL templating, as always, to add lacking functionality to jOOQ: https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating/ I hope this helps Lukas -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO6tKP5%2BnY80eru%2Bk7JW3KpiaDs7dTSZHqa7Q-Lcih4_%3Dw%40mail.gmail.com.
