Thread: Unsigned types
Hi all, Just a quick question. I have a 64 bit type (int8) which needs the range 0 through 2**64. In otherwords an int8 unsigned type. Is it possible to declare this using Postgres 7.1.x? If not, can anyone suggest a way around it? Best regards, Shane -- Shane Wegner: shane@cm.nu http://www.cm.nu/~shane/ PGP: 1024D/FFE3035D A0ED DAC4 77EC D674 5487 5B5C 4F89 9A4E FFE3 035D
Shane Wegner wrote: > Hi all, > > Just a quick question. I have a 64 bit type (int8) which > needs the range 0 through 2**64. In otherwords an int8 > unsigned type. Is it possible to declare this using > Postgres 7.1.x? If not, can anyone suggest a way around > it? > > Best regards, > Shane > > -- > Shane Wegner: shane@cm.nu > http://www.cm.nu/~shane/ > PGP: 1024D/FFE3035D > A0ED DAC4 77EC D674 5487 > 5B5C 4F89 9A4E FFE3 035D > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html I think it can be done using numeric(20,0) type it is a 20 digits precission 0 decimal storage.