On Tue, Oct 1, 2013 at 10:25 AM, David Johnston <pol...@yahoo.com> wrote: > Amit Kapila-2 wrote >> While reading documentation for SET command, I observed that FROM >> CURRENT syntax and its description is missing from SET command's >> syntax page (http://www.postgresql.org/docs/devel/static/sql-set.html). >> >> Do you think that documentation should be updated for the same or is >> there any reason why it is not documented? > > It is documented as part of "CREATE FUNCTION" since its use is only valid in > that context.
Not only as part of "CREATE FUNCTION", but as part of "ALTER DATABASE", "ALTER ROLE", "ALTER FUNCTION" syntax as well. In all these places other syntax of "SET" is also used and described. I think you are right that syntax <SET .. FROM CURRENT> is mainly used in context with few other SQL statements, but as it is part of SET command, so isn't it better to mention the syntax on SET page and may be explain a bit about its usage? > The paragraph with the link to CREATE FUNCTION seems > sufficient to notify and direct people to the needed description for this. After explaining the usage in short, may be can provide links to all other statements where it can be used, but I think syntax <SET .. FROM CURRENT> should be there with SET command's other syntax. With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
