On Sun, 2012-05-13 at 20:09 +0200, Lukas Eder wrote: > > Murray: as a workaround, you can do something like "lower(val1) > LIKE > > lower(val2)".
That's working well, thanks. > > Yes, that would be my immediate suggestion too. That's actually how > jOOQ would simulate ILIKE in other database dialects, although I'll > have to read into collations, and whether there is any difference when > doing this comparison with LOWER() or UPPER() > > > 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. > > I agree with that. It's a simple addition and will be implemented in > jOOQ 2.4.0: > https://sourceforge.net/apps/trac/jooq/ticket/1423 Thank you. -- Murray Cumming [email protected] www.murrayc.com www.openismus.com
