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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
Дата
Msg-id Pine.LNX.4.21.0002191455270.474-100000@localhost.localdomain
обсуждение исходный текст
Ответ на Re: [HACKERS] ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'  (wieck@debis.com (Jan Wieck))
Список pgsql-hackers
On 2000-02-17, Jan Wieck mentioned:

>     IMHO  a  value  floating  around should be kept NUMERIC or in
>     it's string representation until it's finally clear where  it
>     is dropped (int2/4/8, float4/8, numeric or return to client).

Actually, the hierarchy float8, float4, numeric, int8, int4, int2 might
just be right. The standard specifies that float<x> + numeric = float<y>
(where perhaps x == y, not sure). On the other hand, it is also quite
clear that a constant of the form 123.45 is a numeric literal.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: SQL compliance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] gram.y foreign keys