Re: "oracle to postgresql" conversion

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Devrim GÜNDÜZ <devrim(at)CommandPrompt(dot)com>
Cc: Shane Ambler <pgsql(at)Sheeky(dot)Biz>, Kevin Hunter <hunteke(at)earlham(dot)edu>, altudela(at)gmail(dot)com, PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: "oracle to postgresql" conversion
Date: 2007-03-09 18:57:32
Message-ID: 1173466651.20651.294.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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);

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2007-03-09 19:02:31 Re: Setting week starting day
Previous Message Kenneth Downs 2007-03-09 18:53:15 Re: HIPPA (was Re: Anyone know ...)