Re: [GENERAL] Running functions that return void in psql

2004-12-15 Thread Richard Huxton
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. Thanks. I always return

[GENERAL] Running functions that return void in psql

2004-12-15 Thread Eric Brown
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. Thanks. ---(end o

Re: [GENERAL] Running functions that return void in psql

2004-12-15 Thread Michael Fuhr
On Wed, Dec 15, 2004 at 12:19:14AM -0800, 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 t

Re: [GENERAL] Running functions that return void in psql

2004-12-15 Thread Eric Brown
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 jus

Re: [GENERAL] Running functions that return void in psql

2004-12-15 Thread Neil Conway
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