Re: BUG #3092: character varying and integer cannot be matched

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Rass" <net-flight(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3092: character varying and integer cannot be matched
Date: 2007-03-01 16:41:54
Message-ID: 25265.1172767314@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Andrew Rass" <net-flight(at)gmx(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Joey Wang 2007-03-01 21:48:34 BUG #3095: LDAP authentication parsing incorrectly
Previous Message Tom Lane 2007-03-01 16:28:40 Re: BUG #3085: Performance BUG