Re: [Gusdev-gusdev] GUS to PostgreSQL

[Angel P. <an...@pc...>]

On Feb 20, 2004, at 3:46 PM, Laurie Kramer wrote:
>
> I am joining this discussion late, but would like to get involved as
> soon as possible in order to get GUS up and running here at Princeton.
> on PostgreSQL 7.3 (is that what others are using?) Steve and Angel,
> have either of you looked into the ora2pg perl module?  It is at
> http://www.samse.fr/GPL/ora2pg/ and requires an Oracle connection
> in order to run.
>
No I have not. When I get some time next week, I'll look into it.

>
> The PostgreSQL numeric data types are different from those in Oracle 
> and this
> raises the issue of how to convert them.  There is no equivalent of 
> the NUMBER(10)
> or NUMBER(12) in the assay table above, for example, in PostgreSQL.  
> The common
> integer types are int2, int4 and int8.  There is a numeric type which 
> supports
> precision and scale but it is much slower than the integer types.  
> Hence, we
> *must* come to agreement on this conversion issue.  Do I hear any 
> volunteers?
>
We use NUMBER mainly for integers, so one of the int types would do. 
What is the precision of these ints? Are these signed ints?
  -99 > int2 > +99

BTW thanks very much for the converted SQL.

Angel