pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsmallfloat with postgresql
2+ messages / 2 participants
[nested] [flat]
* smallfloat with postgresql
@ 2003-08-26 23:31 Alessandro Depetro <alex@mamcoop.it>
0 siblings, 1 reply; 2+ messages in thread
From: Alessandro Depetro @ 2003-08-26 23:31 UTC (permalink / raw)
To: pgsql-sql
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: smallfloat with postgresql
@ 2003-08-28 03:42 Bruno Wolff III <bruno@wolff.to>
parent: Alessandro Depetro <alex@mamcoop.it>
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2003-08-28 03:42 UTC (permalink / raw)
To: Alessandro Depetro <alex@mamcoop.it>; +Cc: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-28 03:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-26 23:31 smallfloat with postgresql Alessandro Depetro <alex@mamcoop.it>
2003-08-28 03:42 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox