Re: Cast in PG 8.3

Franklin Haut <franklin(dot)haut(at)gmail(dot)com> writes:
> Create Table temp (id int4);
> insert into temp values (1215);
> insert into temp values (1216);
> insert into temp values (1217);
> insert into temp values (1218);
> insert into temp values (1219);
> insert into temp values (1220);
> insert into temp values (1221);
> insert into temp values (1222);
> SELECT * FROM TEMP WHERE id ilike ('%122%');
>
> return ok, 3 rows (1220, 1221 and 1222)

That usage is simply bizarre. Why don't you define the column as text,
instead, if that's the type of query you intend to perform on it?

regards, tom lane