Re: LIKE and ESCAPING in JDBC Select Statement

From: Andrew Lindesay <apl(at)lindesay(dot)co(dot)nz>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: LIKE and ESCAPING in JDBC Select Statement
Date: 2010-01-29 21:48:56
Message-ID: 93B5DCBA-EEF1-4438-B7C8-A15C751235DE@lindesay.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 statement has 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sven Hafner 2010-01-30 02:40:37 Is there a schema parameter for the jdbc URL ?
Previous Message Kris Jurka 2010-01-29 21:43:31 Re: Object types and ResultSets (java.sql.Struct)