Re: "oracle to postgresql" conversion - Mailing list pgsql-general

From Scott Marlowe
Subject Re: "oracle to postgresql" conversion
Date
Msg-id 1173466651.20651.294.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: "oracle to postgresql" conversion  (Devrim GÜNDÜZ <devrim@CommandPrompt.com>)
Responses Re: "oracle to postgresql" conversion  ("Chris Fischer" <Chris.Fischer@channeladvisor.com>)
List pgsql-general
On Thu, 2007-03-08 at 16:05, Devrim GÜNDÜZ wrote:
> Hi,
>
> On Fri, 2007-03-09 at 05:21 +1030, Shane Ambler wrote:
> > NUMBER is Oracle's version of NUMERIC - Oracle will use both but
> > probably only Oracle will use NUMBER.
>
> Really? I thought Oracle's NUMBER ~ PostgreSQL's (BIG)INT?

Not sure.  It let me assign a precision to it, so I figured it wasn't
int based.  In fact, it accepts precision up to 38, just like numeric,
and it accepts non-decimal portions, i.e.:

number(20,4);

pgsql-general by date:

Previous
From: Kenneth Downs
Date:
Subject: Re: HIPPA (was Re: Anyone know ...)
Next
From: Bruno Wolff III
Date:
Subject: Re: Setting week starting day