Thread: combining strings to make a query
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
You can do full-text search in postgres now using ts_vectors. I'd recommend going that route. Doing like comparisons is not a good idea if you don't know the first part of the string you are searching for....It appears to be much faster from my experience to search for ab% than it is to search for %ab%. On Tue, Jul 12, 2011 at 7:51 PM, Wes James <comptekki@gmail.com> wrote: > 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 >
Thank you for the tsvectors info! -wes On Wed, Jul 13, 2011 at 12:11 AM, Kevin Crain <kevin.crain1@gmail.com> wrote: > You can do full-text search in postgres now using ts_vectors. I'd > recommend going that route. Doing like comparisons is not a good idea > if you don't know the first part of the string you are searching > for....It appears to be much faster from my experience to search for > ab% than it is to search for %ab%. > > On Tue, Jul 12, 2011 at 7:51 PM, Wes James <comptekki@gmail.com> wrote: >> 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 >> >