Re: rowcount function in postgres??? - Mailing list 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