Re: Proposal - temporal contrib module

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Proposal - temporal contrib module
Дата
Msg-id 87k4y9e1dq.fsf@hi-media-techno.com
обсуждение исходный текст
Ответ на Re: Proposal - temporal contrib module  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
Jeff Davis <pgsql@j-davis.com> writes:
> If I understand what you're saying, you're alluding to a type where you
> can do things like:
>   RANGE(timestamptz)
> which would be equivalent to a PERIOD.

The RANGE approach sounds so much better from here, as I have the
prefix_range example nearby... it'd be nice if it could benefit.

> Typmod almost provides enough flexibility, but it can't store a full
> OID, so we'd need to get creative. There are probably some other issues
> here as well, because the current type system isn't really designed for
> this kind of thing. Do you have any ideas or guidance here?

When talking about the extension facility it has been said PostGIS is
being creative for lacking of typmod capabilities. It could mean it's
past time for a typmod reality check?

Regards,
-- 
dim


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: operator exclusion constraints
Следующее
От: Fujii Masao
Дата:
Сообщение: Architecture of walreceiver (Streaming Replication)