Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general