Re: TODO question - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: TODO question
Date
Msg-id 3C2B9362.836706A5@fourpalms.org
Whole thread Raw
In response to TODO question  ("Pavlo Baron" <pb@pbit.org>)
List pgsql-hackers
> This TODO-item "SELECT col FROM tab WHERE numeric_col = 10.1 fails, requires
> quotes" - is it already fixed? ...

thomas=# create table t3 (n numeric);
CREATE
thomas=# select * from t3 where n = 10.1;
ERROR:  Unable to identify an operator '=' for types 'numeric' and
'double precision'You will have to retype this query using an explicit cast
thomas=# select * from t3 where n = '10.1';n 
---
(0 rows)

                  - Thomas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Implicit cast of literal in SQL statements
Next
From: "Pavlo Baron"
Date:
Subject: Re: TODO question