On Tue, Jul 15, 2003 at 12:59:34 +0200, Florian Weimer <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match