On Friday 19 December 2008 01:29:06 you wrote: > Aarni <aarni@xxxxxxxx> writes: > > "ERROR: operator does not exist: character varying = integer at > > character 286 HINT: No operator matches the given name and argument > > type(s). You might need to add explicit type casts." > > > > Quick fix to sql statements eg. > > > > ... WHERE CAST (your_char AS INTEGER) = integer ... > > ... WHERE CAST (your_char AS INTEGER) IN (1,2,3,...) > > Note that this is *not* what was happening in 8.2. There it was casting > them to text and doing a text comparison. In the case of integer and > equality they're probably equivalent. However < and > will behave quite > differently. That's why the casts disappeared -- you probably weren't > running the queries you thought you were running in 8.2 and previously. Hi Gregory, Hmm, yes I did note this. Afterwards, though. "Previously ... was automatically cast to text, for most (though not all) built-in data type ... automatic casts too often caused surprising behavior." Luckily enough, I did not get funny or unexpected results with the few queries in one particular application I had to fix for 8.3.3. Best regards, -- Aarni Ruuhimäki -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
