Re: efficiency of wildcards at both ends - Mailing list pgsql-general

On 06/20/12 10:37 AM, Edson Richter wrote:
>
> select * from tb1
>   where nome like 'CARLOS%' or reverse(nome) like reverse('%CARLOS')
>
> Should return same results as
> select * from tb1
>   where nome like '%CARLOS%'

no, that won't match 'abcCARLOSxyx'



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast