Re: rowcount

This is exactly what I needed.
Thanks a lot.

-----Original Message-----
From: Samuel J. Sutjiono [mailto:ssutjiono(at)wc-group(dot)com]
Sent: Wednesday, May 01, 2002 1:42 PM
To: Mike Mascari; Anna Dorofiyenko
Cc: Pgsql-General
Subject: Re: [GENERAL] rowcount

That's correct.

DECLARE
rec_added int;

Begin
Insert.....
Get Diagnostics rec_added = ROW_COUNT;
IF rec_added > 0 then

Regards,
Sam

----- Original Message -----
From: "Mike Mascari" <mascarm(at)mascari(dot)com>
To: "Anna Dorofiyenko" <anna(dot)dorofiyenko(at)xdrive(dot)com>
Cc: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, May 01, 2002 3:02 PM
Subject: Re: [GENERAL] rowcount

> > Anna Dorofiyenko wrote:
> >
> > Hello, list.
> > How can I get in PL/pgSQL number of rows affected by insert/update?
> >
> > I'm looking to do something like:
> > insert into...
> > If rowcount>0
> > then ...
>
> I believe its GET DIAGNOSTICS:
>
> GET DIAGNOSTICS rowcount = ROW_COUNT;
>
> The docs seem pretty paltry on the subject, but here's a link:
>
> http://www.postgresql.org/idocs/index.php?plpgsql-statements.html
>
> >
> > Thank you.
> > Anna
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>