Обсуждение: date ambiguity in view documentation

Поиск
Список
Период
Сортировка

date ambiguity in view documentation

От
rauldmiller@gmail.com
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/sql-createview.html
Description:

Historically, there has been an issue with the concept of "current time" in
the context of view definitions.

Do you mean the current time when the view was created? Or do you mean the
current time when the view was queried? (And, if the latter, is it the time
when the query started or is this time continually updated for different
rows?)

Currently, neither the documentation on date functions nor the documentation
on create view covers this issue. But this needs to be documented.