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