Re: Decimal vs.Numeric vs. Int & type for OID

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Nikhil G(dot) Daddikar" <ngd(at)iname(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Decimal vs.Numeric vs. Int & type for OID
Date: 2000-12-13 20:25:28
Message-ID: Pine.LNX.4.30.0012132123090.1277-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Nikhil G. Daddikar writes:

> It is unclear to me what the real difference is and when to use what.
> Any pointers would be greatly appreaciated.

Integers are integers (uh...)

Numeric is for exact fixed-point decimal numbers. Monetary amounts are a
good example. Decimal is equivalent to numeric.

The oid type should only be used as a foreign key to an oid column.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joel Burton 2000-12-13 21:38:23 Re: Selecting Most Recent Row
Previous Message Stuart Statman 2000-12-13 20:09:06 RE: How to represent a tree-structure in a relational database