Re: BUG #5068: LIKE - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #5068: LIKE
Date
Msg-id 1253430519.20098.0.camel@vanquo.pezone.net
Whole thread Raw
In response to BUG #5068: LIKE  ("Paulo" <correio.vip@gmail.com>)
List pgsql-bugs
On Sun, 2009-09-20 at 01:00 +0000, Paulo wrote:
> like to select a field containing Numeric 4 and compared with a
> char(30)
> field.
> In oracle and postgresql to version 8.2 worked perfectly, now the new
> version no longer works, as we have many queries in this format.

Hard to say without having the complete schema and query, but I suspect
that you are running afoul of the restricted implicit casts.  You might
need to insert explicit casts.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5066: plperl issues with perl_destruct() and END blocks
Next
From: "Kenaniah Cerny"
Date:
Subject: BUG #5069: Segfault