Skip site navigation (1) Skip section navigation (2)

Re: which type matches Oracle's NUMBER type best?

From: doctor(at)fruitbat(dot)org
To: scrappy(at)hub(dot)org (The Hermit Hacker)
Cc: dave(at)turbocat(dot)de (David Wetzel), pgsql-ports(at)hub(dot)org
Subject: Re: which type matches Oracle's NUMBER type best?
Date: 2000-07-19 19:55:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-ports
The Hermit Hacker said ...
> talked this one over with one of our Oracle guys here at work a month or
> so back ... seems that *everything* for Oracle is a NUMBER ... whether its
> an INT or a DECIMAL or what ... 
> Its there 'jack of all trades' sort of type that everything equates to
> ... it. int == number with a precision of 0 ... or somethign like that ...

Oracle's NUMBER type is a superset of other numeric datatypes.  It can
contain integers, floats, decimals, all of quite a large percision and
scale.  You can use the other types (INTEGER, DECIMAL, FLOAT, etc), and
PL/SQL will honor their structure, but NUMBER gives you the best-of-breed
solution for storing numeric data. 

There isn't really a good equivalent in Postgres.  Really, it depends on
your application data.  You should spend some time modeling your data to
see what you really need.

> On Wed, 19 Jul 2000, David Wetzel wrote:
> > Hi,
> > 
> > which type matches Oracle's NUMBER type best?
> > What ca I store in Oracle's NUMBER types?
> > 
> > TIA

Peter A. Castro (doctor(at)fruitbat(dot)org) or (pcastro(at)us(dot)oracle(dot)com)

In response to

pgsql-ports by date

Next:From: Peter EisentrautDate: 2000-07-19 22:46:01
Subject: Re: Shared library search paths
Previous:From: The Hermit HackerDate: 2000-07-19 17:41:13
Subject: Re: which type matches Oracle's NUMBER type best?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group