Re: [Gusdev-gusdev] GUS to PostgreSQL

[Laurie K. <lk...@mo...>]

Angel Pizarro wrote:

> 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


Yes.

-32768 >= int2 >= +32767    (int2 == smallint)

-2147483648 >= int4 >= +2147483647   (int4 == integer)

-9223372036854775808 >= int8 >= 9223372036854775807   (int8 == bigint)


Neither int2 nor int8 values are recommended for use in indexed fields.
My vote is to use the "integer" keyword for most attributes, reserving
"smallint" for those with just a few values, unless they are indexed.
Other opinions?

> BTW thanks very much for the converted SQL.
>
You're welcome.  I learned a lot.
Laurie