Re: Running functions that return void in psql

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