LIKE and ESCAPING in JDBC Select Statement

Поиск
Список
Период
Сортировка
От Andrew Lindesay
Тема LIKE and ESCAPING in JDBC Select Statement
Дата
Msg-id EBA5F58E-BE84-4AB0-AB8B-72167B21295E@lindesay.co.nz
обсуждение исходный текст
Ответы Re: LIKE and ESCAPING in JDBC Select Statement  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
Hello;

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
SELECT ... WHERE ... AND (t0.MESSAGE ILIKE ?) {escape '|'} LIMIT 50
SELECT ... WHERE ... AND (t0.MESSAGE ILIKE ?) LIMIT 50 {escape '|'}

It seems that there is a problem with all of them.  If anybody has used this before and could give me some guidance,
thatwould be great. 

Regards;

___
Andrew Lindesay
www.lindesay.co.nz


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Simon Temple
Дата:
Сообщение: ParameterMetaData getPrecision() always zero?
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: LIKE and ESCAPING in JDBC Select Statement