Re: Running functions that return void in psql

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Running functions that return void in psql
Дата
Msg-id 41BFFEE1.2000305@archonet.com
обсуждение исходный текст
Ответ на Running functions that return void in psql  (Eric Brown <eric.brown@propel.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: java.sql.SQLException: ERROR: Relation 38868974 does
Следующее
От: Eric Brown
Дата:
Сообщение: pgplsql SELECT INTO ... FOR UPDATE (transaction/locking question)