Re: can I define own variables?

> > 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