Thank you for the tsvectors info! -wes
On Wed, Jul 13, 2011 at 12:11 AM, Kevin Crain <kevin.cra...@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 <compte...@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 >> > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
