This is exactly what I needed.
Thanks a lot.
-----Original Message-----
From: Samuel J. Sutjiono [mailto:ssutjiono@wc-group.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@mascari.com>
To: "Anna Dorofiyenko" <anna.dorofiyenko@xdrive.com>
Cc: "Pgsql-General" <pgsql-general@postgresql.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>