Re: Decimal vs.Numeric vs. Int & type for OID - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Decimal vs.Numeric vs. Int & type for OID
Date
Msg-id Pine.LNX.4.30.0012132123090.1277-100000@peter.localdomain
Whole thread Raw
In response to Decimal vs.Numeric vs. Int & type for OID  ("Nikhil G. Daddikar" <ngd@iname.com>)
List 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@gmx.net       http://yi.org/peter-e/



pgsql-sql by date:

Previous
From: miguel sofer
Date:
Subject: Re: How to represent a tree-structure in a relational database
Next
From: "Joel Burton"
Date:
Subject: Re: Selecting Most Recent Row