From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Integer Question - Does Limit Value Make Sense |
Date: | 2006-11-26 00:48:25 |
Message-ID: | 20061126004825.59196.qmail@web33313.mail.mud.yahoo.com |
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.
>
thanks, Tom.
oe1
> regards, tom lane
>
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-11-26 06:08:11 | Re: Integer Question - Does Limit Value Make Sense |
Previous Message | operationsengineer1 | 2006-11-26 00:47:44 | Re: Integer Question - Does Limit Value Make Sense |