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
|
| Список | 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 по дате отправления: