Equivalent to sql%rowcount or @@rowcount

From: "vijaykumar M" <m_vijaykumar(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Equivalent to sql%rowcount or @@rowcount
Date: 2003-07-25 06:04:55
Message-ID: BAY2-F55DEJmGzrLCCt00001fb2@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<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 -------------&nbsp;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>

Attachment Content-Type Size
unknown_filename text/html 577 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-07-25 08:05:21 Re: Equivalent to sql%rowcount or @@rowcount
Previous Message Dan Weeks 2003-07-24 23:31:13 Re: silly NULL question