combining strings to make a query - Mailing list pgsql-sql

From Wes James
Subject combining strings to make a query
Date
Msg-id CAFjCMHtpbUh6Q-=aJmkC=XpTYVqiPUXkK9KYW09rcZLTYVgPig@mail.gmail.com
Whole thread Raw
Responses Re: combining strings to make a query  (Kevin Crain <kevin.crain1@gmail.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Miguel Angel Conte
Date:
Subject: Re: Max column number.
Next
From: Kevin Crain
Date:
Subject: Re: interesting sequence