Re: session variable and/or global variable in plpgsql

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: postgres(at)pivert(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: session variable and/or global variable in plpgsql
Date: 2006-03-03 15:11:34
Message-ID: 200603031511.k23FBYc09104@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

postgres(at)pivert(dot)org wrote:
> Hi,
>
> Is it possible to set a custom session variable and/or global variable in
> plpgsql ?

No. You can create a temporary or non-temporary table and select from
that.

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mr. Dan 2006-03-03 16:31:51 checkpoint_segments
Previous Message Olivier Boissard 2006-03-03 15:05:50 Re: call an external script from pgsql