Support for Postgresql ESCAPE keyword for use with LIKE

[Max Kremer]

Postgres supports setting an escape character as part of the query when using the LIKE predicate. Is there any support for this in JOOQ?

From the docs: https://www.postgresql.org/docs/9.5/static/functions-matching.html

string LIKE pattern [ESCAPE escape-character]

[Lukas Eder]

Hi Max,

Thanks for your enquiry. jOOQ doesn't specifically allow for using that escape keyword (maybe we should: https://github.com/jOOQ/jOOQ/issues/5621), you can just use the like() overload that takes that character as a second argument:

http://www.jooq.org/javadoc/latest/org/jooq/Field.html#like-java.lang.String-char-

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 jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.