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