Re: using BIGINT VS NUMERIC

[Paul DuBois]

At 8:19 PM -0500 8/8/01, Timothy E. Cronin wrote:
>After RTFM ...
>
>when creating a table
>
>the following works
>id BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT
>
>but the following syntax fails:
>id NUMERIC PRIMARY KEY NOT NULL AUTO_INCREMENT
>
>I get the following error.
>
>Incorrect column specifier for column id

AUTO_INCREMENT columns should be used only with integer types.
NUMERIC isn't integer.

-- 
Paul DuBois, paul@stripped