Re: [HACKERS] I don't like LIKE

> > 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=>

Can't reproduce:test=> create table tx(i int);CREATEtest=> create index xx on tx(i);CREATEtest=> select * from tx where
ilike '3';i-(0 rows)test=> vacuum;VACUUMtest=> select * from tx where i like '3';i-(0 rows)
 


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