Re: Mapping Oracle types to PostgreSQL types

Shridhar Daithankar wrote:

> Jean-Michel POURE wrote:
>
>> Dear friends,
>>
>> I would like to port Compiere CRM from Oracle to PostgreSQL (and
>> release it for free).
>>
>> At first I would like to convert the data schema. This is not
>> difficult as Compiere is written using portable types like NUMBER
>> (i,d) which can be replaced by NUMERIC (i,d), etc... A series of
>> Search/Replace is sufficiant. There are other solutions in Contrib to
>> connect to Oracle and export the data (Bruce). Don't blame me to
>> search in another (silly) direction...
>
>
> Rather than declaring numeric, create them as integer/float of
> appropriate size and add appropriate constraints. Numeric can be
> slower for large data load w.r.t native integers.

float is *not* an alternative to numeric. While integer or int8 should
be usable for NUMBER(i), the non-rounding precision of numeric is vital
for such an application.

Regards,
Andreas