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);
Try: 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: > al_shopov -- Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
