Re: Integer Question - Does Limit Value Make Sense

[<operationsengineer1(at)yahoo(dot)com>]

> <operationsengineer1(at)yahoo(dot)com> writes:
> > it looks to me like it choked on the format
> > "integer(10)" part.  
> 
> > is limit a mysql specific issue for integer?
> 
> Absolutely.  There might be another DB or two that
> takes the above
> syntax, but it's certainly nowhere to be found in
> the SQL spec.
> SQL99 defines the numeric types as
> 
>          <exact numeric type> ::=
>                 NUMERIC [ <left paren> <precision> [
> <comma> <scale> ] <right paren> ]
>               | DECIMAL [ <left paren> <precision> [
> <comma> <scale> ] <right paren> ]
>               | DEC [ <left paren> <precision> [
> <comma> <scale> ] <right paren> ]
>               | INTEGER
>               | INT
>               | SMALLINT
> 
>          <approximate numeric type> ::=
>                 FLOAT [ <left paren> <precision>
> <right paren> ]
>               | REAL
>               | DOUBLE PRECISION
> 
> INTEGER is stated to have scale zero and
> implementation-defined precision.
> 

thanks, Tom.

oe1
> 			regards, tom lane
> 



 
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com