| From: | Luis Amigo <lamigo(at)atc(dot)unican(dot)es> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Unsigned types |
| Date: | 2001-11-19 07:58:04 |
| Message-ID: | 3BF8BB8B.B4C58CF0@bonito.atc.unican.es |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)cm(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Zanella | 2001-11-19 10:30:11 | checking date format with postgresql without creating a table |
| Previous Message | Joshua Adam Ginsberg | 2001-11-19 06:56:15 | Packages for RH7.2 |