[GENERAL] Functions returning RECORD

[Craig Bryden]

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