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