| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | "Penchalaiah P(dot)" <penchalaiahp(at)infics(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: hi let me know the solution to this question |
| Date: | 2006-07-18 05:34:42 |
| Message-ID: | 20060718053442.GA9694@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tue, Jul 18, 2006 at 10:46:29AM +0530, Penchalaiah P. wrote:
> Can u let me know if at all any system defined variable exists to check
> whether insert , update , and delete is successfully executed in a
> stored procedure........
>
> So that I can perform some steps based on the result of execution if
> possible please send me the sample code...............
Depending on what you mean by "successfully executed," see "Obtaining
the Result Status" or "Trapping Errors" in the PL/pgSQL documentation
(error trapping is available in 8.0 and later).
http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curtis Scheer | 2006-07-18 14:26:30 | How to pass array of values to a stored procedure |
| Previous Message | Penchalaiah P. | 2006-07-18 05:16:29 | hi let me know the solution to this question |