Re: [HACKERS] I don't like LIKE

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> There seems to be a problem with MakeIndexable(), though I haven't
> confirmed that the problem lies there:
>
> postgres=> select * from t1 where i like '2';
> ERROR: pg_atoi: error in "2_": can't parse "_"
>
> istm that this query should behave itself, or at least fail in some
> other way :(
>
> I'll guess that, even though there isn't a wildcard to pattern match,
> MakeIndexable() is adding a trailing \377 to the string?

Please post example. Works here:

select * from pg_class where rename like '2';

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026