Re: LIKE and ESCAPING in JDBC Select Statement - Mailing list pgsql-jdbc

Hi Kris;

I am very sure that was my first attempt and it didn't work yesterday, but I have now done exactly this and the
statementhas parsed.  Thanks for looking at it for me. 

cheers.

>> 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.


___
Andrew Lindesay
www.lindesay.co.nz