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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
