Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 196ED9FA25C for ; Thu, 8 Feb 2007 12:57:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 13696-10 for ; Thu, 8 Feb 2007 12:57:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by postgresql.org (Postfix) with ESMTP id 26E0E9FB1CB for ; Thu, 8 Feb 2007 12:57:33 -0400 (AST) Received: from [192.168.7.5] ([71.101.65.69]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JD500IWXLOV3OD0@vms048.mailsrvcs.net> for pgsql-sql@postgresql.org; Thu, 08 Feb 2007 10:55:44 -0600 (CST) Date: Thu, 08 Feb 2007 11:56:07 -0500 From: Joe Subject: Re: Open a Transaction In-reply-to: <55c095e90702080850re95fc47j95afdea67579c933@mail.gmail.com> To: Ezequias Rodrigues da Rocha Cc: pgsql-sql@postgresql.org Message-id: <1170953767.697.44.camel@pampa> Organization: Freedom Circle, LLC MIME-version: 1.0 X-Mailer: Evolution 2.8.3 FreeBSD GNOME Team Port Content-type: text/plain Content-transfer-encoding: 7bit References: <55c095e90702080850re95fc47j95afdea67579c933@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/94 X-Sequence-Number: 27428 Hi Ezequias, On Thu, 2007-02-08 at 14:50 -0200, Ezequias Rodrigues da Rocha wrote: > Hi list, > > Could someone tell me what is wrong on this statement ? > > Start Transaction The above should read begin; > delete from base.something > where > id in( > 41503, > 41504, > 41505, > 41506, > 41507, > 41508, > 41509, > 41510, > 41511, > 41512, > 41513, > 41514, > 41515, > 41516, > 41517, > 41518, > 41519, > 41520, > 41521, > 41522, > 41523, > 41524, > 41525, > 41526, > 41527, > 41528, Remove the extra comma. > ) > end; Remove 'end'. > Commit; Joe