Re: Unsigned types - Mailing list pgsql-general

From Luis Amigo
Subject Re: Unsigned types
Date
Msg-id 3BF8BB8B.B4C58CF0@bonito.atc.unican.es
Whole thread Raw
In response to Unsigned types  (Shane Wegner <shane@cm.nu>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Joshua Adam Ginsberg
Date:
Subject: Packages for RH7.2
Next
From: "Arsalan Zaidi"
Date:
Subject: nested select query take too long