Search Postgresql Archives

Re: 21 bit number for sequence

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

On Sat, 15 Apr 2006, Shoaib Mir wrote:

Actually that is the application requirment to use 21 bit numbers as porting
it from Oracle where it used to work.

21 bits are no problem as bigints have 64 bits. If you mean decimal digits please explicitly say so. A bit is a binary digit.

Yeah now i have decided to use a numeric data type in a table and use that
to write my own nextval and currval functions for that purpose.

you could also try to fix you application which most certainly is severly broken if it tries to store specific numbers in a sequence.

Greetings
Christian

--
Christian Kratzer                       ck@xxxxxxxxx
CK Software GmbH                        http://www.cksoft.de/
Phone: +49 7452 889 135                 Fax: +49 7452 889 136


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux