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

From Bruno Wolff III
Subject Re: IPv4 addresses, unsigned integers, space
Date
Msg-id 20030715133838.GB10467@wolff.to
Whole thread Raw
In response to IPv4 addresses, unsigned integers, space  (Florian Weimer <fw@deneb.enyo.de>)
Responses Re: IPv4 addresses, unsigned integers, space  (Florian Weimer <fw@deneb.enyo.de>)
List pgsql-general
On Tue, Jul 15, 2003 at 12:59:34 +0200,
  Florian Weimer <fw@deneb.enyo.de> wrote:
> If I switched from signed integers to unsigned integers (and from INET
> to "real" IPv4 addresses, consisting of the relevant 32 bits only) I
> think I could save about 25% of my table size.
>
> 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.

pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: Are you frustrated with PostgreSQL
Next
From: "Chris Boget"
Date:
Subject: Re: Are you frustrated with PostgreSQL