Re: [HACKERS] [PROPOSAL] Temporal query processing with range types

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] [PROPOSAL] Temporal query processing with range types
Дата
Msg-id CAFj8pRB12fd7Ke3SFS_Ek9t6udizJ6zUHNoTnDdHSgZ7FgHSsg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] [PROPOSAL] Temporal query processing with range types  (Peter Moser <pitiz29a@gmail.com>)
Ответы Re: [HACKERS] [PROPOSAL] Temporal query processing with range types  (Peter Moser <pitiz29a@gmail.com>)
Список pgsql-hackers
Дерево обсуждения


2017-09-22 10:15 GMT+02:00 Peter Moser <pitiz29a@gmail.com>:
2017-09-22 10:06 GMT+02:00 Pavel Stehule <pavel.stehule@gmail.com>:
> ANSI SQL 2011 has temporal data support
>
> https://www.slideshare.net/CraigBaumunk/temporal-extensions-tosql20112012010438

As operations it only supports temporal inner joins using the overlap predicate.
Temporal aggregation, temporal outer joins, temporal duplicate
elimination, and temporal set operations are not supported in
SQL:2011.
Please see [1] Section 2.5 Future directions.

Best regards,
Anton, Johann, Michael, Peter


[1] https://cs.ulb.ac.be/public/_media/teaching/infoh415/tempfeaturessql2011.pdf

Thank you for info.

Currently Postgres has zero support for SQL:2011 temporal tables. Isn't better start with already standard features than appends some without standard? The standard has some concept and if we start out of this concept, then the result will be far to standard probably.

Regards

Pavel

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

Предыдущее
От: Peter Moser
Дата:
Сообщение: Re: [HACKERS] [PROPOSAL] Temporal query processing with range types
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] GUC for cleanup indexes threshold.