From: | "Bob Whitehouse" <bwhitehouse(at)geeknest(dot)com> |
---|---|
To: | "pgsql-novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Returning function results... |
Date: | 2001-04-20 19:52:25 |
Message-ID: | 013401c0c9d3$6c187b00$a6a0fea9@amsite.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
How do I return a record to a function?
When I try to add the function below to my database I get this error:
psql:/path/:825: NOTICE: ProcedureCreate: type 'record' is not yet defined
CREATE FUNCTION get_last_respondent(INT4)
RETURNS RECORD
AS 'DECLARE
int_issue_id_var ALIAS FOR $1;
rec_person RECORD;
BEGIN
SELECT h.who, iss.id AS issue, h.id AS histid
INTO rec_person
FROM history h, issues iss
WHERE iss.id = int_issue_id_var
AND iss.id = h.issue
AND h.h_type = 3
AND h.who <> iss.submitter
ORDER BY histid DESC;
RETURN rec_person;
END;'
LANGUAGE 'plpgsql';
Thanks, Bob
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Hallstrom | 2001-04-20 21:03:48 | Re: postgres installation on FBSD fails |
Previous Message | Tom Lane | 2001-04-20 17:50:16 | Re: BUG ? ... CURSOR AS VIEW ... MOVE ... CRASH |