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, that would be great.
Regards;
___
Andrew Lindesay
www.lindesay.co.nz