Re: numeric and float converts to int differently?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: numeric and float converts to int differently?
Дата
Msg-id 87brs1gr4y.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: numeric and float converts to int differently?  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Список pgsql-sql
"SZÛCS Gábor" <surrano@mailbox.hu> writes:

> > cannot see is that the float values are not actually exactly 0.5
> 
> Yes I could guess that (floating point vs fixed), but is this a coincidence
> that both '0.5'::float and '-0.5'::float are closer to 0, whereas they could
> be closer to +/-1, as well as both closer to the lower or upper bound.

Wouldn't 0.5 and -0.5 be representable exactly as floats?


-- 
greg



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

Предыдущее
От: SZUCS Gábor
Дата:
Сообщение: Re: URGENT!!! changing Column size
Следующее
От: SZUCS Gábor
Дата:
Сообщение: Re: numeric and float converts to int differently?