=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE FUNCTION xy(int4) RETURNS SETOF RECORD AS ' > ... > RETURN v_rec; > ... > ' LANGUAGE 'plpgsql';
> ERROR: RETURN cannot have a parameter in function returning set; use > RETURN NEXT at or near "v_rec" at character 324 You were never supposed to do that, although prior releases did not check for the mistake. See http://www.postgresql.org/docs/7.4/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING : When a PL/pgSQL function is declared to return SETOF sometype, the : procedure to follow is slightly different. In that case, the individual : items to return are specified in RETURN NEXT commands, and then a final : RETURN command with no argument is used to indicate that the function : has finished executing. > ERROR: function xy(integer) does not exist > HINT: No function matches the given name and argument types. You may > need to add explicit type casts. 8.0 not only detects the error, but does so during CREATE FUNCTION (because it's treated as a syntax error). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
