Thread: 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;

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