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.

            regards, tom lane