X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DB06AD1B2BD for ; Tue, 15 Jun 2004 09:28:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25303-03 for ; Tue, 15 Jun 2004 12:28:49 +0000 (GMT) Received: from mail18.messagelabs.com (mail18.messagelabs.com [202.153.127.245]) by svr1.postgresql.org (Postfix) with SMTP id DBD70D1B54D for ; Tue, 15 Jun 2004 09:28:42 -0300 (ADT) X-VirusChecked: Checked X-Env-Sender: Pankaj.Chugh@Lntinfotech.com X-Msg-Ref: server-12.tower-18.messagelabs.com!1087302522!3550727 X-StarScan-Version: 5.2.11; banners=lntinfotech.com,-,- X-Originating-IP: [203.199.118.66] Received: (qmail 32438 invoked from network); 15 Jun 2004 12:28:43 -0000 Received: from vashiout.lntinfotech.com (203.199.118.66) by server-12.tower-18.messagelabs.com with SMTP; 15 Jun 2004 12:28:43 -0000 Received: from vashi.lntinfotech.com ([203.199.118.15]) by Vashiout.lntinfotech.com (Lotus Domino Release 5.0.11) with ESMTP id 2004061517585829:1477 ; Tue, 15 Jun 2004 17:58:58 +0530 Subject: Number of rows effected To: X-Mailer: Lotus Notes Release 5.0.9 November 16, 2001 Message-ID: From: "Pankaj Chugh" Date: Tue, 15 Jun 2004 17:58:34 +0530 MIME-Version: 1.0 X-MIMETrack: Serialize by Router on VASHI/LNTINFOTECH(Release 5.0.11 |July 24, 2002) at 06/15/2004 05:58:39 PM, Itemize by SMTP Server on VASHIOUT/LNTINFOTECH(Release 5.0.11 |July 24, 2002) at 06/15/2004 05:58:58 PM, Serialize by Router on VASHIOUT/LNTINFOTECH(Release 5.0.11 |July 24, 2002) at 06/15/2004 05:59:00 PM, Serialize complete at 06/15/2004 05:59:00 PM Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/167 X-Sequence-Number: 18112 Hi, I have a question how to get number of rows effected in last DML in Postgres. actually i am using procedures for each DML so when a update procedure is called i have to return no of rows effected by it. Thanks Pankaj Chugh This email may contain confidential or privileged information for the intended recipient(s). If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. Thanks ______________________________________________________________________