X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id A6715D1C97A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Jul 2003 06:04:57 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 13437-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Jul 2003 03:04:11 -0300 (ADT)
Received: from hotmail.com (bay2-f55.bay2.hotmail.com [65.54.247.55])
	by svr1.postgresql.org (Postfix) with ESMTP id 6A4B5D1C968
	for <pgsql-sql@postgresql.org>; Fri, 25 Jul 2003 03:04:55 -0300 (ADT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Thu, 24 Jul 2003 23:04:55 -0700
Received: from 202.63.107.19 by by2fd.bay2.hotmail.msn.com with HTTP;
	Fri, 25 Jul 2003 06:04:55 GMT
X-Originating-IP: [202.63.107.19]
X-Originating-Email: [m_vijaykumar@hotmail.com]
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
Mime-Version: 1.0
Content-Type: text/html
Message-ID: <BAY2-F55DEJmGzrLCCt00001fb2@hotmail.com>
X-OriginalArrivalTime: 25 Jul 2003 06:04:55.0619 (UTC)
	FILETIME=[ABA85130:01C35272]
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_30_40
X-Spam-Level: 
X-Archive-Number: 200307/369
X-Sequence-Number: 14483

<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>