Re: Is it possible to search for sub-strings... - Mailing list pgsql-general

From Mitch Vincent
Subject Re: Is it possible to search for sub-strings...
Date
Msg-id 010a01c02255$c5f13de0$0200000a@doot
Whole thread Raw
In response to Is it possible to search for sub-strings...  (John Draper <crunch@webcrunchers.com>)
List pgsql-general
> >LIKE can use indexes, ~* can not, that's LIKE's main advantage (at least
in
> >my opinion).
> >
>
> ~ does use indexes, ~* doesnt,
>  but then nor does the equivalent upper(columnname) LIKE 'TERM'. Make sure
> you're comparing apples with apples.

Indeed, all that's true but did I say otherwise? What I said was true, just
not as detailed as yours.. Apples to apples though, the origional poster
just wanted to search for substrings and said nothing about case.

No big deal, just clearing that up.

-Mitch





pgsql-general by date:

Previous
From: Steve Heaven
Date:
Subject: Re: Is it possible to search for sub-strings...
Next
From: Tom Lane
Date:
Subject: Re: Re[2]: WTF is going on with PG_VERSION?