Re: 9.5 Create Function Set From Current taken at creation time? - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: 9.5 Create Function Set From Current taken at creation time?
Date
Msg-id CAKFQuwYVPyk9BnhDgHi27kPWd4SJp0Ko3ihqDf5SQE-4-iN_Zw@mail.gmail.com
Whole thread Raw
In response to Re: 9.5 Create Function Set From Current taken at creation time?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 9.5 Create Function Set From Current taken at creation time?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Tue, Aug 9, 2016 at 9:43 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "David G. Johnston" <david.g.johnston@gmail.com> writes:
> > Can we change the second sentence in the above quote to something like:=
=E2=80=8B
>
> > SET FROM CURRENT is a convenience expression to capture the result of
> > current_setting('setting name') at the time of the function's creation.
> [if
> > more than just convenience an example of when this is useful would be
> nice].
>
> "Convenience" normally means that there's some other way to get the same
> result.  I do not know of one, and I doubt we'd have introduced the
> feature if there was.
>

Fair enough...=E2=80=8Bso:

SET FROM CURRENT saves the
=E2=80=8B[creating] =E2=80=8B
session's current value of the parameter as the value to be applied when
the function is entered.

=E2=80=8BDavid J.
=E2=80=8B

pgsql-bugs by date:

Previous
From: "Rader, David"
Date:
Subject: Re: BUG #14285: Chinese locale and windows
Next
From: Tom Lane
Date:
Subject: Re: 9.5 Create Function Set From Current taken at creation time?