On Thu, Jul 20, 2006 at 10:46:27PM -0400, Tom Lane wrote:
> "David Fetter" <david(at)fetter(dot)org> writes:
> > is there some way to let the right hand side of SET be the (TEXT)
> > output of a function?
> No. SET is a utility command and utility commands generally don't
> do expression evaluation. (There are some specific reasons why not
> for SET, but I won't get into that here.)
> However, you can get the desired effect in various other ways; see
> the set_config() function, or try updating the pg_settings view ...
foo=> UPDATE pg_catalog.pg_settings SET setting = 'bar,' || setting
-[ RECORD 1 ]----------------
set_config | bar,$user,public
That's a neat trick :)
psql foo foo
foo=> SHOW search_path ;
How do I make it permanent?
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Remember to vote!
In response to
pgsql-bugs by date
|Next:||From: Alaa El Gohary||Date: 2006-07-21 07:41:02|
|Subject: BUG #2543: Performance delay acrros the same day|
|Previous:||From: Tom Lane||Date: 2006-07-21 02:46:27|
|Subject: Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out |