Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does Chronus support temporal projections?

0
Posted

Does Chronus support temporal projections?

0

Yes. Many temporal queries will wish to project selected columns in a table before operating on them. The resulting projection may be coalesced or uncoalesced. Given that many temporal queries will operate in this way, we would like to avoid requiring that the projection be performed in a separate SELECT statement because this approach would necessitate the writing of two SELECT statements for many temporal queries. Instead, we allow projection to be performed in the FROM clause of a SELECT statement. These projections are named so that we can refer to them in the subsequent WHERE clause. They are coalesced by default; the keyword UNCOALESCED may be used to turn off coalescing. Suppose we had the following table called EMPLOYEE and wanted to select people who had worked for more than two months at any job. Name Job ValidTime J. Smith doctor {[14/Feb/2002-‘+’]} P. Jones dentist {[1/Apr/2002-‘+’]} R.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.