From: vijaykumar M <m_vijaykumar@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Equivalent to sql%rowcount or @@rowcount
Date: Fri, 25 Jul 2003 06:04:55 +0000
Message-ID: <BAY2-F55DEJmGzrLCCt00001fb2@hotmail.com> (raw)
<html><div style='background-color:'><DIV>
<P><BR><BR></P>Hi All! </DIV>is it possible to get in sql number of rows affected by the sql last insert,
<DIV></DIV>
<P>update or delete statement?? </P>
<P>for eg, </P>
<P>oracle ------------- sql%rowcount.</P>
<P>sqlserver ------------ select @@rowcount.</P>
<P>Any help will be highly appreciated..</P>
<DIV></DIV>
<DIV></DIV>Thanks
<DIV></DIV>
<DIV></DIV>Regards,
<DIV>Vijay</DIV></div><br clear=all><hr>Cool new emoticons. Lots of colour! <a href="http://g.msn.com/8HMIENIN/2737??PS=">On MSN Messenger V6.0</a> </html>
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: m_vijaykumar@hotmail.com
Subject: Re: Equivalent to sql%rowcount or @@rowcount
In-Reply-To: <BAY2-F55DEJmGzrLCCt00001fb2@hotmail.com>
* 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