what data type to store fixed size integer?

From: Arash pajoohande <apajoohande(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: what data type to store fixed size integer?
Date: 2011-04-10 11:41:33
Message-ID: BANLkTikNQ6DBH4Pyq09hN-hsz4NOUg7v5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi there
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
what is the best data type (fastest) to store it? any help would be
appreciated.

thanks in advance
Arash

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-04-10 12:34:33 Re: what data type to store fixed size integer?
Previous Message Sim Zacks 2011-04-10 11:20:56 pg_restore problem with type