From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Mitch Vincent <mitch(at)venux(dot)net>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] numeric question.. |
Date: | 2000-01-16 17:14:04 |
Message-ID: | Pine.LNX.4.21.0001152025360.386-100000@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 2000-01-14, Tom Lane mentioned:
> "Mitch Vincent" <mitch(at)venux(dot)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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-01-16 17:35:34 | Re: [SQL] numeric question.. |
Previous Message | Peter Eisentraut | 2000-01-16 17:13:34 | Re: [SQL] Getting environment variables? |