Обсуждение: Unsigned types

Поиск
Список
Период
Сортировка

Unsigned types

От
Shane Wegner
Дата:
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

Re: Unsigned types

От
Luis Amigo
Дата:
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.