Re: Running functions that return void in psql - Mailing list pgsql-general

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