2017-09-22 10:15 GMT+02:00 Peter Moser <pitiz...@gmail.com>: > 2017-09-22 10:06 GMT+02:00 Pavel Stehule <pavel.steh...@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
