Re: [HACKERS] I don't like LIKE

Bruce Momjian wrote:
> 
> [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';

Maybe he meant something like this (using 6.4.2)

hannu=> \d t
Table    = t
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-------+
| i                                | int4                            
|     4 |
+----------------------------------+----------------------------------+-------+
hannu=> create index indx on t(i);
CREATE
hannu=> vacuum;
VACUUM
hannu=> select * from t where i like '1';
ERROR:  pg_atoi: error in "1ÿ": can't parse "ÿ"
hannu=>

---------------------
Hannu