Re: Integer Question - Does Limit Value Make Sense - Mailing list pgsql-novice

> <operationsengineer1@yahoo.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