Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] numeric question.. - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: [SQL] numeric question..
Date
Msg-id Pine.LNX.4.21.0001152025360.386-100000@localhost.localdomain
Whole thread Raw
In response to Re: [SQL] numeric question..  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [SQL] numeric question..  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
On 2000-01-14, Tom Lane mentioned:

> "Mitch Vincent" <mitch@venux.net> writes:
> > I tried doing them in decimal(9,2) too and well, it added them as numeric
> > anyway -- I guess that's a dead end for a while?
> 
> DECIMAL is just an alias for NUMERIC, as far as I know...

NUMERIC specifies the data type exact numeric, with the decimal precision
and scale specified by the <precision> and <scale>.
DECIMAL specifies the data type exact numeric, with the decimal scale
specified by the <scale> and the implementation-defined decimal precision
equal to or greater than the value of the specified <precision>.

Up to this day I'm wondering what exactly this means ...

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

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] Getting environment variables?
Next
From: Tom Lane
Date:
Subject: Re: [SQL] numeric question..