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

From Michael Fuhr
Subject Re: Running functions that return void in psql
Date
Msg-id 20041215084706.GB30423@winnie.fuhr.org
Whole thread Raw
In response to Running functions that return void in psql  (Eric Brown <eric.brown@propel.com>)
List pgsql-general
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 that return void from psql. Thanks.

You could issue queries to verify that the expected inserts, updates,
or deletes (and only those operations) were actually done.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Running functions that return void in psql
Next
From: Eric Brown
Date:
Subject: Re: Running functions that return void in psql