Re: Oracle/PostgreSQL incompatibilities

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, rainer(dot)klute(at)epost(dot)de, pgsql-hackers(at)postgresql(dot)org, klute(at)rainer-klute(dot)de
Subject: Re: Oracle/PostgreSQL incompatibilities
Date: 2003-10-04 06:50:03
Message-ID: 3F7E6D9B.8070702@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Finger or brain trouble, here is the correction :

>NUMBER -> INTEGER when transporting schemas from Oracle to Pg.
>(This needs a little care - as NUMBER in Oracle has bigger *precision*
than INTEGER in Pg)

Thinking about this a bit more, its probably fine to just substitute
NUMERIC for NUMBER, but obviously INTEGER is going to perform better if
it can be used.

regards

Mark

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2003-10-04 08:09:49 Re: Dreaming About Redesigning SQL
Previous Message Tom Lane 2003-10-04 03:55:42 Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...