Обсуждение: smallfloat with postgresql

Поиск
Список
Период
Сортировка

smallfloat with postgresql

От
"Alessandro Depetro"
Дата:
sorry again (I am not smoking crack, only drinking some good ceres...)

smallint is not right (it is right for postgresql as a data type as read from
the guide)... The real data type is "smallfloat" (found in my informix tables)

so, Can I safely use NUMERIC as a data type for monetary computation instead
of smallfloat ???

alessandro depetro

--
Coop Service Noncello s.c.a r.l. onlus
http://www.mamcoop.it/



Re: smallfloat with postgresql

От
Bruno Wolff III
Дата:
On Wed, Aug 27, 2003 at 01:31:23 +0200, Alessandro Depetro <alex@mamcoop.it> wrote:
> 
> so, Can I safely use NUMERIC as a data type for monetary computation instead
> of smallfloat ???

NUMERIC represents decimal numbers exactly so is suitable for monetary
types using even decimal fractions.