Sergio,

> > Separately, it may be a personal thing but I would use INTEGER and BIGINT
> types for NUMERIC( 9,0) and NUMERIC( 18,0) domains.
>
> I don't remember why at the moment, but I was told, some time ago, to use
> numeric(9,0) instead of integer... could you please tell me why you prefer
> integer? I'm always very interested in this kind of "conceptual" things.

I think of INTEGER/BIGINT as a "native" datatypes and NUMERIC/DECIMAL as "abstract" types which have more overhead. So, whenever possible I use "native" types.

In your case, since there are no decimals, the values are effectively integers.

I may be wrong about the overhead (given my track record over the last while)


Sean