Float/Numeric?

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Float/Numeric?
Date: 1999-11-22 21:06:16
Message-ID: 19991122220616.A1895@fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Could anyone tell me why the following does not work without a cast?

mm=> select * from test;
f|i|a
------+-+---------------------
404.90|1|{0,1,2,3,4,5,6,7,8,9}
(1 row)

mm=> select i from test where f=404.90
mm-> ;
ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
You will have to retype this query using an explicit cast
mm=> select i from test where f::float=404.90;
i
-
1
(1 row)

Shouldn't there be an implicit cast between numeric and float?

Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael(at)Fam-Meskes(dot)De | Use PostgreSQL!

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vince Vielhaber 1999-11-22 21:11:34 Re: [HACKERS] Re: postgres RPM build on Suse linux 6.2
Previous Message Bruce Momjian 1999-11-22 19:37:54 Re: AW: [HACKERS] Getting OID in psql of recent insert