At 11:41 AM 11/7/2000 -0500, Griffin, Patrick J. wrote:

>So,
>
>create table test1 (
> field1 integer,
> field2 numeric(9),
> field3 decimal(4,2));
>
>They are all integers, but
>
>field1 gets a subtype of 0
>field2 gets a subtype of 1
>field3 gets a subtype of 2
>
>Do I understand this correctly?

Right. And the purpose is to make it possible for
interfaces like ODBC, IBO, etc. to handle numbers
better. When we keep precision, we can also enforce
the limits of the numeric type (another great leap
backward toward standards).

Regards,

Ann