Re: [SQL] numeric question..

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

In response to

Responses

Browse pgsql-sql by date

  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?