Re: context in plpgsql functions

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Ian Barwick <barwick(at)gmx(dot)net>, Gianni Mariani <gianni(at)mariani(dot)ws>, pgsql-general(at)postgresql(dot)org
Subject: Re: context in plpgsql functions
Date: 2003-05-16 22:46:09
Message-ID: 20030516224609.70679.qmail@web20803.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Ian Barwick <barwick(at)gmx(dot)net> wrote:
> On Friday 16 May 2003 20:46, Gianni Mariani wrote:
> > I've been using PostgreSQL 7.3.2.
> >
> > What, if any, way is there to share a context
> (global rowtype variable)
> > between plpgsql functions ?
>
> If you mean something like Oracle's PL/SQL packages,
> which can
> contain package global variables, then unfortunately
> not.

I believe the usual workaround is to insert the values
in a table which has been created for that purpose.

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2003-05-16 23:07:14 Re: - what protocol for an Internet postgres
Previous Message Ron Johnson 2003-05-16 22:29:05 Re: realtime data inserts