| From: | Christian Kratzer <ck(at)cksoft(dot)de> |
|---|---|
| To: | Shoaib Mir <shoaibmir(at)gmail(dot)com> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 21 bit number for sequence |
| Date: | 2006-04-15 08:18:37 |
| Message-ID: | 20060415101508.W63374@vesihiisi.cksoft.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)cksoft(dot)de
CK Software GmbH http://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kari Pahula | 2006-04-15 09:50:49 | Re: Curious UDP packets |
| Previous Message | Shoaib Mir | 2006-04-15 08:11:49 | Re: 21 bit number for sequence |