Re: BUG #5068: LIKE

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Paulo <correio(dot)vip(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5068: LIKE
Date: 2009-09-20 07:08:39
Message-ID: 1253430519.20098.0.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kenaniah Cerny 2009-09-20 07:34:40 BUG #5069: Segfault
Previous Message Tom Lane 2009-09-20 03:43:26 Re: BUG #5066: plperl issues with perl_destruct() and END blocks