Thanks. I forgot the 'return;' and the error message led me in the
wrong direction. Thanks!
On Dec 15, 2004, at 12:43 AM, Neil Conway wrote:
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 4: Don't 'kill -9' the postmaster
