Re: LIKE and ESCAPING in JDBC Select Statement

On Sat, 30 Jan 2010, Andrew Lindesay wrote:

> I am trying to use the JDBC LIKE escape clause with PG 8.4 and the PG
> 8.4 JDBC driver.
>
> So far I have tried;
>
> SELECT ... WHERE ... AND (t0.MESSAGE ILIKE ? {escape '|'}) LIMIT 50

This works for me as attached.  Please be more clear what your problem is.

Kris Jurka