Re: LIKE and ESCAPING in JDBC Select Statement

From: Kris Jurka <books(at)ejurka(dot)com>
To: Andrew Lindesay <apl(at)lindesay(dot)co(dot)nz>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: LIKE and ESCAPING in JDBC Select Statement
Date: 2010-01-29 21:17:25
Message-ID: alpine.BSO.2.00.1001291616340.31378@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Attachment Content-Type Size
Escape.java text/plain 533 bytes

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2010-01-29 21:35:50 Re: ParameterMetaData getPrecision() always zero?
Previous Message Andrew Lindesay 2010-01-29 20:02:50 LIKE and ESCAPING in JDBC Select Statement