I suspected that might be the case and understand perfectly. I’ll likely make my own function which calls substring.
Thanks. PS I did send direct email. I assume your ellipsis trimmed off the detail > On Dec 4, 2020, at 1:12 AM, Lukas Eder <[email protected]> wrote: > > > > >> 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. -- 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/25BD15A4-F15A-4414-BAB6-D839DD7CA28D%40gmail.com.
