Re: [HACKERS] I don't like LIKE - Mailing list pgsql-hackers

Bruce Momjian <maillist@candle.pha.pa.us> writes:
> Can't reproduce:

>     test=> select * from tx where i like '3';
>     i
>     -
>     (0 rows)

If you've built with USE_LOCALE you won't see the failure,
because the parser doesn't add the right-side index qualification
in that case (at least not in 6.5; 6.4 did).

We still need a better solution for non-ASCII locales, too...
        regards, tom lane