Skip site navigation (1) Skip section navigation (2)

Re: global variables in plpgsql?

From: John DeSoi <desoi(at)pgedit(dot)com>
To: dave(dot)bath(at)unix(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: global variables in plpgsql?
Date: 2006-04-11 05:15:37
Message-ID: F5F6CA70-2C8C-4786-8333-B2C86CF3FFA6@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Apr 10, 2006, at 9:17 PM, dave(dot)bath(at)unix(dot)net wrote:

> So, a couple of questions....
> 1) Can you declare global values from plpgsql?
> 2) If so, is there a way of avoiding namespace pollution?
>    (perhaps the equivalent to Oracle's use of plsql package
>    variables)

plpgsql does not have global variables.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


In response to

pgsql-sql by date

Next:From: Timo TuomiDate: 2006-04-11 09:34:22
Subject: Please help with a query..
Previous:From: Tom LaneDate: 2006-04-11 02:57:57
Subject: Re: Special meaning of NL string

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group