From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
---|---|
To: | Ryan Bradetich <rbradetich(at)gmail(dot)com> |
Cc: | Dann Corbit <DCorbit(at)connx(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [RFC] Unsigned integer support. |
Date: | 2008-07-26 16:06:21 |
Message-ID: | 20080726160621.GA25131@it.is.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Ryan,
I agree, I have had applications use uint types to avoid using
a larger data type. I have actually had to patch an application
developed for MySQL uint8 to signed int8 on PostgreSQL. In that
case, the only operations that were performed where assignment
and lookup. If we need to use the numeric type for calculations,
that would be okay as long as the data is actually stored as
8-bytes, not numeric. It would certainly increase the ease of
moving an application from MySQL to PostgreSQL.
Cheers,
Ken
On Fri, Jul 25, 2008 at 08:50:02PM -0700, Ryan Bradetich wrote:
> Hello Dann,
>
> On Fri, Jul 25, 2008 at 1:06 PM, Dann Corbit <DCorbit(at)connx(dot)com> wrote:
>
> > At the cost of one bit of storage, you have compatible types using
>
> Thanks for your review and feedback! Unfortunately, I do need the full range
> of the unsigned types for the project I am looking at. The reason I started
> working on these types is because it seemed wasteful to use the next size
> larger signed integer for the storage type of the unsigned integer.
>
> Thanks for the suggestion!
>
> - Ryan
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-07-26 16:20:04 | Re: pg_dump additional options for performance |
Previous Message | Andrew Gierth | 2008-07-26 15:19:31 | Executor question |