| From: | Shay Moreno <moreno(at)tdk(dot)dk> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bob Whitehouse <bwhitehouse(at)geeknest(dot)com> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Questions about writing functions... |
| Date: | 2001-04-20 09:45:20 |
| Message-ID: | 5D38890DAE46D41186A800508B6F7187026FFDC8@oestmb010-b0.tdk.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)amdocs(dot)com
/ \ Campanha fita ASCII mailto:moreno(at)tdk(dot)dk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thorsten Mauch | 2001-04-20 10:43:42 | How to install postgres 7.1 on SuSE 7.1 |
| Previous Message | tankgirl | 2001-04-20 09:36:01 | System Catalogs |