> > 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);
>
It's little bit strange. It has not dificult implementation, but It's redundand.
what is more readable and more simple?
a) var := (SHOW system_var);
b) var := (SELECT current_setting('system_var'));
c) var := current_setting('system_var');
I thing so c).
Pavel