"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