X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E5C449FB22F for ; Thu, 14 Sep 2006 03:34:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 70877-03 for ; Thu, 14 Sep 2006 06:34:49 +0000 (UTC) X-Greylist: delayed 00:26:38.606235 by SQLgrey- Received: from ns.neo.co.jp (ns.neo.co.jp [219.101.217.194]) by postgresql.org (Postfix) with ESMTP id A130D9FB1EA for ; Thu, 14 Sep 2006 03:34:49 -0300 (ADT) Received: from localhost (ns.neo.co.jp [127.0.0.1]) by ns.neo.co.jp (Postfix) with ESMTP id 9EFF68C0E1 for ; Thu, 14 Sep 2006 15:07:00 +0900 (JST) Received: from ns.neo.co.jp ([127.0.0.1]) by localhost (ns.neo.co.jp [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06541-01 for ; Thu, 14 Sep 2006 15:06:54 +0900 (JST) Received: from [172.18.3.69] (unknown [172.18.3.69]) by ns.neo.co.jp (Postfix) with ESMTP id 2ADE88C0DE for ; Thu, 14 Sep 2006 15:06:53 +0900 (JST) Message-ID: <4508F1A7.3040907@sangtao.net> Date: Thu, 14 Sep 2006 15:07:35 +0900 From: Javanesevn User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: How to delete multiple records Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at neo.co.jp X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/95 X-Sequence-Number: 26306 Dear all, I execute this query on below: delete from PRODUCT where exists ( select product_id, item_id from PRODUCT where research_date < '2006-01-01' ) this query deleted all records data in PRODUCT table. The subquery return only some records. Tell me about other idea? and What's wrong from this query. Best regards, -Javanesevn