Horton

Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
Cc: Michael Meskes <meskes@postgreSQL.org>, PostgreSQL Hacker <pgsql-hackers@postgreSQL.org>
Date: 2000-02-16T14:46:08Z
Lists: pgsql-hackers 
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> One hesitation I have is the performance hit in mixing FLOAT and
> NUMERIC; I (probably) don't want to make NUMERIC the "best" numeric
> type, since it is potentially so slow.

I concur --- I'd be inclined to leave FLOAT8 as the top of the
hierarchy.  But NUMERIC could be stuck in there between int and float,
no?  (int-vs-numeric ops certainly must be promoted to numeric...)

			regards, tom lane