Hi,
Is there a way to define a function as a procedure, I mean a function that returns nothing.
CREATE OR REPLACE FUNCTION foo(<in-parameters>)
AS $$
BEGIN
<update-some-tables>
END;
$$ LANGUAGE 'plpgsql';
Actually, PostgreSQL complains as a “function result type must be specified”. I can patch my function so that it compiles but that won’t be really nice:
CREATE OR REPLACE FUNCTION foo(<in-parameters>)
RETURNS int
AS $$
BEGIN
<update-some-tables>
RETURN 1;
END;
$$ LANGUAGE 'plpgsql';
Is there any other prettier way to do that?
Thanks,
--
Daniel
