Re: IPv4 addresses, unsigned integers, space - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: IPv4 addresses, unsigned integers, space
Date
Msg-id 20030716161810.GA1263@wolff.to
Whole thread Raw
In response to Re: IPv4 addresses, unsigned integers, space  (Florian Weimer <fw@deneb.enyo.de>)
List pgsql-general
On Tue, Jul 15, 2003 at 22:12:13 +0200,
  Florian Weimer <fw@deneb.enyo.de> wrote:
> Bruno Wolff III <bruno@wolff.to> writes:
>
> >> Does PostgreSQL already implement these data types?  I don't think so.
> >> If I succeed in implementing them, would you accept a patch?
> >
> > You can have unsigned integers using a domain with a check constraint.
>
> They take twice as much storage as necessary.

This depends on the range of numbers you need. If you specifically need
integers greater than 2^31-1 and don't need any greater than 2^32-1, then
that is true. In most cases there won't be a per item space penalty.

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?