Re: BUG #3092: character varying and integer cannot be matched - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3092: character varying and integer cannot be matched
Date
Msg-id 25265.1172767314@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3092: character varying and integer cannot be matched  ("Andrew Rass" <net-flight@gmx.net>)
List pgsql-bugs
"Andrew Rass" <net-flight@gmx.net> writes:
> ERROR: IN types character varying and integer cannot be matched

> postgresql 7.4.7 did this
> and now it did this problem like describe

This is not a bug; it's an intentional tightening of the behavior.
You'll need to put in a cast so that the system knows whether you want
an integer comparison or a textual comparison to occur.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3085: Performance BUG
Next
From: mfwitten@MIT.EDU
Date:
Subject: Re: BUG #3087: Endiannes, of all things