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);
CREATE
test=> create index xx on tx(i);
CREATE
test=> select * from tx where i like '3';
i
-
(0 rows)

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

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