Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C52C39FB324 for ; Thu, 8 Feb 2007 13:26:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 98423-01-9 for ; Thu, 8 Feb 2007 13:26:32 -0400 (AST) X-Greylist: delayed 00:27:37.900089 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 861EE9FA09C for ; Thu, 8 Feb 2007 13:26:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from tavolara.isolaweb.it (unknown [80.247.74.3]) by svr4.postgresql.org (Postfix) with ESMTP id 50C775AF8C6 for ; Thu, 8 Feb 2007 16:58:51 +0000 (GMT) Received: from ROBERTO.tekno-soft.it (host90-140-static.22-87-r.retail.telecomitalia.it [87.22.140.90]) by tavolara.isolaweb.it (Postfix) with ESMTP id 7358E49804B; Thu, 8 Feb 2007 17:55:02 +0100 (CET) X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9 Date: Thu, 08 Feb 2007 17:58:18 +0100 To: "Ezequias Rodrigues da Rocha" From: Roberto Fichera Subject: Re: Open a Transaction Cc: pgsql-sql@postgresql.org In-Reply-To: <55c095e90702080850re95fc47j95afdea67579c933@mail.gmail.com > References: <55c095e90702080850re95fc47j95afdea67579c933@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Message-Id: <20070208165502.7358E49804B@tavolara.isolaweb.it> X-IsolaWeb-MailScanner-Information: Please contact the ISP for more information X-IsolaWeb-MailScanner: Found to be clean X-MailScanner-From: kernel@tekno-soft.it X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.135 tagged_above=0 required=5 tests=BAYES_60, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200702/97 X-Sequence-Number: 27431 At 17.50 08/02/2007, Ezequias Rodrigues da Rocha wrote: >Hi list, > >Could someone tell me what is wrong on this statement ? > >Start Transaction >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, ^ this comma I guess ;-)! >) >end; >Commit; > >-- > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Atenciosamente (Sincerely) > Ezequias Rodrigues da Rocha > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- >A pior das democracias ainda é melhor do que a melhor das ditaduras >The worst of democracies is still better than the better of dictatorships >http://ezequiasrocha.blogspot.com/ > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend > Roberto Fichera.