| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | Arash pajoohande <apajoohande(at)gmail(dot)com>, "List, Postgres" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: what data type to store fixed size integer? |
| Date: | 2011-04-10 15:59:23 |
| Message-ID: | 9168.1302451163@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> writes:
> On 04/10/2011 07:41 PM, Arash pajoohande wrote:
>> I wan to store a 10 digits integer in a column of table.
>> the data type does not need any arithmetic aperations (as of integers).
>> maybe its good to use bigint, but it is Postgres specific and is not
>> part of SQL standards
> int8 , which is just another name for bigint. I don't know what the SQL
> standard name for the data type is, but I'm pretty sure there is one.
> Anyone know the details?
SMALLINT and BIGINT are standardized type names in SQL:2003 and later.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | abdede@onvol.net | 2011-04-10 20:29:59 | |
| Previous Message | Ivano Luberti | 2011-04-10 15:06:34 | Re: searchable database |