Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group