pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Michael Fuhr <mike@fuhr.org>
To: Karthikeyan Sundaram <skarthi98@hotmail.com>
Cc: postgres sql <pgsql-sql@postgresql.org>
Subject: Re: rowcount function in postgres???
Date: Sat, 7 Apr 2007 11:51:00 -0600
Message-ID: <20070407175100.GA80042@winnie.fuhr.org> (raw)
In-Reply-To: <BAY131-W181F25E4A6D4AC7312545FB05B0@phx.gbl>
References: <BAY131-W181F25E4A6D4AC7312545FB05B0@phx.gbl>

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-DIAGNOSTIC...
http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPIN...

-- 
Michael Fuhr

view thread (4+ messages)  latest in thread

Message-ID: <20070407175100.GA80042@winnie.fuhr.org>
Permalink:  ../20070407175100.GA80042@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20070407175100.GA80042@winnie.fuhr.org

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mike@fuhr.org, skarthi98@hotmail.com
  Subject: Re: rowcount function in postgres???
  In-Reply-To: <20070407175100.GA80042@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox