strange change (and error) in 8.3 ?

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: postgresql-general <pgsql-general(at)postgresql(dot)org>
Subject: strange change (and error) in 8.3 ?
Date: 2007-06-14 08:34:09
Message-ID: 9e4684ce0706140134od2df525p479c86e510555103@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2007-06-14 10:24:56 Re: pg_xlog - files are guaranteed to be sequentialynamed?
Previous Message Pavel Stehule 2007-06-14 08:30:03 Re: inner join problem with temporary tables