hi,
this query:
select 1 where '1'::text in (1::int8);
worked fine in 8.2:
# select version();
version
------------------------------------------------------------------------------------------------
PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 (Ubuntu 4.1.2-0ubuntu4)
(1 row)
# select 1 where '1'::text in (1::int8);
?column?
----------
1
(1 row)
but in 8.3 i get:
# select 1 where '1'::text in (1::int8);
ERROR: operator does not exist: text = bigint
LINE 1: select 1 where '1'::text in (1::int8);
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
why? i mean - i see that types are bad, but it worked in 8.2. why it was broken/modified in 8.3?
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz
