Re: IPv4 addresses, unsigned integers, space

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: IPv4 addresses, unsigned integers, space
Date: 2003-07-15 13:38:38
Message-ID: 20030715133838.GB10467@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 15, 2003 at 12:59:34 +0200,
Florian Weimer <fw(at)deneb(dot)enyo(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-07-15 13:42:44 Re: Insert Updates Deletes on Views; Triggers on System Tables
Previous Message Chris Boget 2003-07-15 13:24:59 Re: Are you frustrated with PostgreSQL