Eric Brown wrote:
I've got quite a few plpgsql functions that insert, update or delete. They're all declared to return void. All other functions, I can just run 'select f(...);' from psql to test them. I don't understand how to test these ones that return void from psql.

neilc=# create function xyz() returns void as 'begin return; end;' language 'plpgsql';
CREATE FUNCTION
neilc=# select xyz();
xyz
-----


(1 row)

-Neil

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to