Functions returning RECORD

From: "Craig Bryden" <postgreSQL(at)bryden(dot)co(dot)za>
To: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Functions returning RECORD
Date: 2005-01-13 17:58:33
Message-ID: 001001c4f999$80d08c00$77d417c4@amd2800
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I come from a MS-SQL background and am trying to figure out what is wrong with the function below:
*****************************************************************************************
CREATE OR REPLACE FUNCTION GetAccountInfo (p_AccID int)
RETURNS record
AS
$$
DECLARE
r_Return record;
BEGIN
SELECT a.Field1, a.Field2, a.Field4
INTO r_Return
FROM Account
WHERE a.AccID = p_AccID;

RETURN r_Return;
END;
$$
language 'plpgsql';
*****************************************************************************************
When I run select * from GetAccountInfo (100) I get the following error message: ERROR: a column definition list is required for functions returning "record"

please can someone explain to me how to create a column definition list.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank D. Engel, Jr. 2005-01-13 17:59:43 Re: allowing connections from additional hosts without a restart?
Previous Message Ed L. 2005-01-13 17:33:50 Re: vacuum vs open transactions