Hi all,

I´m testing the new version of PostgreSQL in windows plataform but i have a problem.


In PG 8.2

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)



In PG 8.3

Create Table temp (id integer);
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%');

Error:
operator does not exist: integer ~~* unknown at character 31
HINT:  No operator matches the given name and argument type(s).
You might need to add explicit type casts.


I Know that changing the SQL command to :
SELECT * FROM TEMP WHERE CAST(id AS TEXT) ilike ('%122%');
work´s but for now isn't possible... :(


I Tries  create a cast but the function text doesn't exist more in PG 8.3

CREATE CAST (int AS text) WITH FUNCTION text(int);

can everyone help me to create a cast ou other solution ?

Thank´s


Franklin