Re: Oracle/PostgreSQL incompatibilities - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: Oracle/PostgreSQL incompatibilities
Date
Msg-id 3F7E6D9B.8070702@paradise.net.nz
Whole thread Raw
In response to Re: Oracle/PostgreSQL incompatibilities  (Mark Kirkwood <markir@paradise.net.nz>)
List 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




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Thoughts on maintaining 7.3
Next
From: Hannu Krosing
Date:
Subject: Re: Dreaming About Redesigning SQL