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

Re: Integer Question - Does Limit Value Make Sense

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 (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.
> 

thanks, Tom.

oe1
> 			regards, tom lane
> 



 
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

In response to

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-11-26 06:08:11
Subject: Re: Integer Question - Does Limit Value Make Sense
Previous:From: operationsengineer1Date: 2006-11-26 00:47:44
Subject: Re: Integer Question - Does Limit Value Make Sense

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