Thread: date ambiguity in view documentation

date ambiguity in view documentation

From
rauldmiller@gmail.com
Date:
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.