Re: Documentation for SET var_name FROM CURRENT

On Tue, Oct 1, 2013 at 9:01 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> Amit Kapila escribió:
>> 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?
>
> Did you look at the commit message that introduced it?
  No, I just noticed while reading documentation that although syntax
SET var_name FROM CURRENT works, but the documentation didn't have it.  Commit meesage below explains why it is not
there,but I think as 
it works, it might be better to mention in some form (as described by
David in  previous mail or some other variant).

> commit e7889b83b7059e776f0a3d76bbbdd98687f4592c
> Author: Tom Lane <tgl@sss.pgh.pa.us>
> Date:   Mon Sep 3 18:46:30 2007 +0000
>
>     Support SET FROM CURRENT in CREATE/ALTER FUNCTION, ALTER DATABASE, ALTER ROLE.
>     (Actually, it works as a plain statement too, but I didn't document that
>     because it seems a bit useless.)  Unify VariableResetStmt with
>     VariableSetStmt, and clean up some ancient cruft in the representation of
>     same.
  Thanks for pointing at right location.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com