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

Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'
Date: 2002-09-19 20:45:48
Message-ID: 20020919204548.1D99447608D@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Daniel Serodio (daniel(at)checkforte(dot)com(dot)br) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
 Unable to identify an operator '=' for types 'numeric' and 'double precision'

Long Description
If I create a table with a 'numeric' column, and try to make a query using a "large" numeric literal, it complains about not finding the '=' operator for types 'numeric' and 'double precision'.

CREATE TABLE test_numeric (value numeric);
INSERT INTO test_numeric (value) VALUES (5000469541);
SELECT * FROM test_numeric WHERE value = 5000469541;
ERROR:  Unable to identify an operator '=' for types 'numeric' and 'double precision'
	You will have to retype this query using an explicit cast

The same happens with the '+' operator, for example.

UPDATE test_numeric SET value = value + 14524565363;
ERROR:  Unable to identify an operator '+' for types 'numeric' and 'double precision'
	You will have to retype this query using an explicit cast



Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-09-19 21:10:40
Subject: Re: Server hangs on multiple connections
Previous:From: David ChristianDate: 2002-09-19 20:22:42
Subject: Server hangs on multiple connections

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