Re: IPv4 addresses, unsigned integers, space

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: IPv4 addresses, unsigned integers, space
Дата
Msg-id 20030715133838.GB10467@wolff.to
обсуждение исходный текст
Ответ на IPv4 addresses, unsigned integers, space  (Florian Weimer <fw@deneb.enyo.de>)
Ответы Re: IPv4 addresses, unsigned integers, space  (Florian Weimer <fw@deneb.enyo.de>)
Список 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 по дате отправления:

Предыдущее
От: nolan@celery.tssi.com
Дата:
Сообщение: Re: Are you frustrated with PostgreSQL
Следующее
От: "Chris Boget"
Дата:
Сообщение: Re: Are you frustrated with PostgreSQL