Re: can I define own variables?

Tom Lane wrote:
> Guy Rouillier <guyr-ml1@burntmail.com> writes:
>> I set that up, and using the SHOW command returns the set value.  I
>> searched the archives and I couldn't identify a way to retrieve these
>> values in a trigger function.
>
> http://www.postgresql.org/docs/8.2/static/functions-admin.html#FUNCTIONS-ADMIN-SET-TABLE
>

Thank you, Tom.  Since "select current_setting('uservars.user_name')"
and "SHOW uservars.user_name" are both PostgreSQL extensions, why not
allow them to be used interchangeably?  In short, why isn't the
following legal in a PL/pgsql procedure:

NEW.user_name := (SHOW uservars.user_name);

--
Guy Rouillier