I'm using Erlang and postgresql to build a web interface.  When I
create the query string I get something like:

select * from table where field::text ilike '%\\\\%'

But when I do that (if someone types in '\' for part of the text
search), I get a pg log entry to use E'\\'

How would I use E'' with ilike '%%'.  ilike E'%\\%' doesn't work.

Thanks,

-wes

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to