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.
In response to
pgsql-hackers by date
|Next:||From: Hannu Krosing||Date: 2003-10-04 08:09:49|
|Subject: Re: Dreaming About Redesigning SQL|
|Previous:||From: Tom Lane||Date: 2003-10-04 03:55:42|
|Subject: Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ... |