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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
Дата
Msg-id 2614.950712368@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Ответы RE: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] parser changes