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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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