| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com> |
| Cc: | postgres sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: rowcount function in postgres??? |
| Date: | 2007-04-07 17:51:00 |
| Message-ID: | 20070407175100.GA80042@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
On Sat, Apr 07, 2007 at 10:33:19AM -0700, Karthikeyan Sundaram wrote:
> I am using 8.1.0 postgres and trying to write a plpgsql block.
8.1.8 is the latest version in that branch. Read the Release Notes
for each minor release to see what bug fixes you're missing.
http://www.postgresql.org/docs/8.1/interactive/release.html
> In that I am inserting a row. I want to check to see if the row
> has been inserted or not.
See "Obtaining the Result Status" and "Trapping Errors" in the
PL/pgSQL documentation.
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 | Rodrigo De León | 2007-04-07 17:54:35 | Re: [SQL] rowcount function in postgres??? |
| Previous Message | tom12167 | 2007-04-07 17:47:41 | Porting and Exception handling |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo De León | 2007-04-07 17:54:35 | Re: [SQL] rowcount function in postgres??? |
| Previous Message | Karthikeyan Sundaram | 2007-04-07 17:33:19 | rowcount function in postgres??? |