Home > mailing lists

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

From	Kris Jurka
Subject	Re: LIKE and ESCAPING in JDBC Select Statement
Date	January 29, 2010 20:17:38
Msg-id	alpine.BSO.2.00.1001291616340.31378@leary.csoft.net Whole thread Raw
In response to	LIKE and ESCAPING in JDBC Select Statement (Andrew Lindesay <apl@lindesay.co.nz>)
Responses	Re: LIKE and ESCAPING in JDBC Select Statement (Andrew Lindesay <apl@lindesay.co.nz>)
List	pgsql-jdbc

Tree view

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

Escape.java

pgsql-jdbc by date:

From: Andrew Lindesay
Date: 29 January 2010, 19:45:34
Subject: LIKE and ESCAPING in JDBC Select Statement

From: Kris Jurka
Date: 29 January 2010, 20:36:02
Subject: Re: ParameterMetaData getPrecision() always zero?

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

Attachment

Previous

Next