returning result set

Hi,

I am very new to PostgerSQL and trying to create following function and
return the result set back.

For some reason I am not getting following error.

ERROR: a column definition list is required for functions returning
"record"

This function could return multiple rows.

Any pointers to specific solution will also be appreciated.

Thanks

HG

========================================================

CREATE FUNCTION function1(integer) RETURNS SETOF record AS $$

DECLARE

acodes RECORD;

BEGIN

FOR acodes in

SELECT

case

when $1 = a.col1 then
'******'

else ''

end AS "firstColumn" ,

a.col1,

a.col2

a.col3,

a.col6

FROM table1 a INNER JOIN table2 b ON a.col2 = b.col2

WHERE a.col2 in

(

SELECT col2

FROM table1

WHERE col1 = $1

)

ORDER BY codeId LOOP

return next acodes;

END LOOP;

END;

$$ LANGUAGE plpgsql;

========================================================