Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2A35E1337B49 for ; Thu, 3 Feb 2011 08:10:45 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 62206-03 for ; Thu, 3 Feb 2011 12:10:38 +0000 (UTC) X-Greylist: delayed 00:07:14.937713 by SQLgrey-1.7.6 Received: from rs73.luxsci.com (rs73.luxsci.com [64.49.254.135]) by mail.postgresql.org (Postfix) with ESMTP id B46911337B8C for ; Thu, 3 Feb 2011 08:10:36 -0400 (AST) Received: from GNANAM ([180.151.61.10]) (authenticated bits=0) by rs73.luxsci.com (8.13.8/8.13.8) with ESMTP id p13C3IqG023998; Thu, 3 Feb 2011 06:03:20 -0600 Reply-To: From: "Gnanakumar" To: Subject: Is there a batch/bulk UPDATE syntax available? Date: Thu, 3 Feb 2011 17:30:08 +0530 Organization: Zoniac Software Private Limited Message-ID: <005b01cbc399$e8d99fa0$ba8cdee0$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcvDmea6jrU8FUdsQqmr4GS0XVYLTQ== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201102/9 X-Sequence-Number: 36648 Hi, Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar to multirow VALUES syntax available for INSERT? INSERT Multirow VALUES syntax example: INSERT INTO films (code, title, did, date_prod, kind) VALUES ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'), ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy'); There is a situation in my application, where I am performing lots and lots of updates on individual rows. I am trying to figure out how to make the updates faster. Any other ideas/ways to make updates faster are highly appreciated. Regards, Gnanam