Re: Documentation for SET var_name FROM CURRENT

On Tue, Oct 1, 2013 at 10:25 AM, David Johnston <polobo(at)yahoo(dot)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