Skip site navigation (1) Skip section navigation (2)

Re: Integer Question - Does Limit Value Make Sense

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 (view raw or flat)
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

In response to

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-11-25 20:12:14
Subject: Re: Integer Question - Does Limit Value Make Sense
Previous:From: operationsengineer1Date: 2006-11-25 19:32:34
Subject: Integer Question - Does Limit Value Make Sense

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group