On Thursday 27 November 2008 8:17:10 pm Александър Шопов wrote:
> Hi everyone,
> In pg 8.2 to 8.3 transition there is a new behavior: Non-character data
> types are no longer automatically cast to TEXT
> I understand the reasons, however while we manage to migrate the our
> system, is there a way to get back this behavior? I searched the
> internet and the mailing lists but I found no other solution but
> installing back 8.2.
> I tried to do the following:
> create table test (i integer);
> insert into test values (1);
> select * from test where i = (case when '0'<>'' then '1' else null end);
select * from test where i = (case when '0'<>'' then '1' else null end)::int;
> ERROR: operator does not exist: integer = text
> LINE 1: select * from test where i = (case when '0'<>'' then '1' els...
> HINT: No operator matches the given name and argument type(s). You
> might need to add explicit type casts.
> Kind regards:
In response to
pgsql-general by date
|Next:||From: Alvaro Herrera||Date: 2008-11-28 15:48:55|
|Subject: Re: Very large tables|
|Previous:||From: William Temperley||Date: 2008-11-28 15:40:35|
|Subject: Very large tables|