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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-19 21:10:40 | Re: Server hangs on multiple connections |
Previous Message | David Christian | 2002-09-19 20:22:42 | Server hangs on multiple connections |