On Thu, Jun 23, 2011 at 4:07 PM, Leyne, Sean <Sean@...>wrote:

>
> 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)

It's not an enormous difference, but references to NUMERIC and DECIMAL have
to check the field definition for a scale.

Cheers,

Ann

>

[Non-text portions of this message have been removed]