21 bit number for sequence

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: 21 bit number for sequence
Date: 2006-04-15 05:24:59
Message-ID: bf54be870604142224j3e311914ma8ef5b6047787268@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Right now Sequence by default uses bigint which supports upto 19bit numbers
but I want to use a 21bit that can be supported by NUMERIC datatype. Is
there any way I can sepcify while creating a sequence what datatype to use
or if I can specify to create sequence with numeric datatype?

/Shoaib

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2006-04-15 05:54:09 Re: Querying a BYTEA datatype
Previous Message Tom Lane 2006-04-15 04:15:01 Re: Replacing MD5 hash in pg_auth...