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
>