Murray: as a workaround, you can do something like "lower(val1) LIKE lower(val2)".
Lukas: i too think that support for ILIKE would be a great addition :) Not something with a very high priority though, since there is a workaround available. BTW - I haven't had time yet to test your change to the code generation schemata stuff yet, unfortunately :( On Saturday, May 12, 2012 9:49:31 PM UTC+2, Murray Cumming wrote: > > jooq's Field has a like() method to create a Condition: > > http://www.jooq.org/javadoc/latest/org/jooq/Field.html#like(java.lang.String) > > But how can I use the ILIKE operator provided by PostgreSQL to do > case-insensitive matching?: > http://www.postgresql.org/docs/devel/static/functions-matching.html > > Or do you suggest some other way to do a simple case-insensitive match > for a sub-string inside a field's text value? > > -- > www.murrayc.com > www.openismus.com > >
