Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8' - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
Date
Msg-id 2614.950712368@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Responses RE: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] parser changes