context in plpgsql functions

From: Gianni Mariani <gianni(at)mariani(dot)ws>
To: pgsql-general(at)postgresql(dot)org
Subject: context in plpgsql functions
Date: 2003-05-16 18:46:45
Message-ID: 3EC53215.4050309@mariani.ws
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I've been using PostgreSQL 7.3.2.

What, if any, way is there to share a context (global rowtype variable)
between plpgsql functions ?

Can row types be passed as parameters ? (I seem to have had trouble
doing that)

e.g.

A transaction that looks like:

BEGIN;
select FindContext(5432);
select SomeRandomFunction('111');
COMMIT;

The functions would look somthing like:

CREATE or replace FUNCTION FindContext(int4) RETURNS int4 AS
'
DECLARE
w_key alias for $1;
w_context context%ROWTYPE;
BEGIN

SELECT INTO w_context * FROM contecxt WHERE key = w_key;

-- I want to access w_context in a different method

RETURN 1;

END;
'
LANGUAGE 'plpgsql';

CREATE or replace FUNCTION SomeRandomFunction(int4) RETURNS int4 AS
'
DECLARE
w_stuff alias for $1;
w_context context%ROWTYPE; -- ??????????????
BEGIN

update sometable set key = w_context.key where yadda = w_stuff;

RETURN 1;

END;
'
LANGUAGE 'plpgsql';

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ahoward 2003-05-16 18:49:41 7.3.2, pam, on Linux 2.4.18-18.7.x i686
Previous Message Chris Palmer 2003-05-16 18:42:46 Re: priority on a process