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