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';
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 |