From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | operationsengineer1(at)yahoo(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Integer Question - Does Limit Value Make Sense |
Date: | 2006-11-25 20:10:07 |
Message-ID: | 9433.1164485407@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
<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.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-11-25 20:12:14 | Re: Integer Question - Does Limit Value Make Sense |
Previous Message | operationsengineer1 | 2006-11-25 19:32:34 | Integer Question - Does Limit Value Make Sense |