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

Re: TODO question

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Pavlo Baron <pb(at)pbit(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: TODO question
Date: 2001-12-27 21:32:18
Message-ID: 3C2B9362.836706A5@fourpalms.org (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Pavlo BaronDate: 2001-12-27 21:50:21
Subject: Re: TODO question
Previous:From: Thomas LockhartDate: 2001-12-27 21:28:53
Subject: Re: Implicit cast of literal in SQL statements

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