Re: extended operator classes vs. type interfaces

Поиск
Список
Период
Сортировка
От Nathan Boley
Тема Re: extended operator classes vs. type interfaces
Дата
Msg-id u2p6fa3b6e21004091618re5ad35f5qdb83d009a8e2c62c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: extended operator classes vs. type interfaces  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: extended operator classes vs. type interfaces
Список pgsql-hackers
> The advantage of specifying a + and a - in the type interface is that
> the unit definition can then be specified as part of the type
> declaration itself.  So you can do:
>
> CREATE TYPE ts_sec AS RANGE OVER timestamp (UNIT = '1s');
> CREATE TYPE ts_min AS RANGE OVER timestamp (UNIT = '1m');
>
> All of the stuff about defining + and - is hidden from the user - it's
> part of the type interface, which is pre-created.
>

The disadvantage is that it does not permit irregularly spaced units.

-Nathan


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: GSoC - proposal - Materialized Views in PostgreSQL
Следующее
От: "Erik Rijkers"
Дата:
Сообщение: testing HS/SR - 1 vs 2 performance