Documentation enhancement

Started by Thomas Kellererover 15 years ago2 messagesgeneral
Jump to latest
#1Thomas Kellerer
spam_eater@gmx.net

Hi,

I would like to suggest to enhance the documentation of the CREATE VIEW statement.

I think the fact that a "SELECT *" is internally stored as the expanded column list (valid at the time when the view was created) should be documented together with the CREATE VIEW statement. Especially because the example does use SELECT * to create the view.

Regards
Thomas

#2Bruce Momjian
bruce@momjian.us
In reply to: Thomas Kellerer (#1)
Re: Documentation enhancement

Thomas Kellerer wrote:

Hi,

I would like to suggest to enhance the documentation of the CREATE VIEW
statement.

I think the fact that a "SELECT *" is internally stored as the expanded
column list (valid at the time when the view was created) should be
documented together with the CREATE VIEW statement. Especially because
the example does use SELECT * to create the view.

Agreed. The attached, applied patch documents this behavior.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

Attachments:

/rtmp/view.difftext/x-diffDownload+4-0