Re: Questions about writing functions...

Поиск
Список
Период
Сортировка
От Shay Moreno
Тема Re: Questions about writing functions...
Дата
Msg-id 5D38890DAE46D41186A800508B6F7187026FFDC8@oestmb010-b0.tdk.dk
обсуждение исходный текст
Ответ на Questions about writing functions...  ("Bob Whitehouse" <bwhitehouse@geeknest.com>)
Список pgsql-novice
> > If I write a function that deletes a record from a table, how do I
access
> > the output from the delete operation to see if it completed
successfully?
>
> In 7.1 you could look at the ROW_COUNT statistic field to see how many
> rows were deleted.  I don't think pre-7.1 plpgsql has a way to do that.

    Are there any plans to suport SQLERROR and the SQLCA area, or
similar concepts as described in
http://technet.oracle.com/doc/oracle8i_816/appdev.816/a76942/pc_09err.htm#30
49 or
http://technet.oracle.com/doc/oracle8i_816/appdev.816/a76975/oci02bas.htm#42
5597?

    I tried checking the docs for 7.1 in the Users' Lounge but my access
to them is *very* slow.



--
  _
 / \       Leandro Guimarães Faria Corcete Dutra        +55 (11) 3040 8913
 \ /       Amdocs Brasil Ltda at Tele Danmark                +45 3387 5214
  X   http://terravista.pt./Enseada/1989/     mailto:leandrod@amdocs.com
 / \     Campanha fita ASCII                        mailto:moreno@tdk.dk

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Questions about writing functions...
Следующее
От: Thorsten Mauch
Дата:
Сообщение: How to install postgres 7.1 on SuSE 7.1