Re: Running functions that return void in psql

From: Richard Huxton <dev(at)archonet(dot)com>
To: Eric Brown <eric(dot)brown(at)propel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Running functions that return void in psql
Date: 2004-12-15 09:07:45
Message-ID: 41BFFEE1.2000305@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. Thanks.

I always return boolean or a count of rows affected in these situations.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric Brown 2004-12-15 09:38:53 pgplsql SELECT INTO ... FOR UPDATE (transaction/locking question)
Previous Message Richard Huxton 2004-12-15 09:05:06 Re: java.sql.SQLException: ERROR: Relation 38868974 does