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 по дате отправления: