X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id BE00AD1B8BD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 22 Aug 2003 07:02:06 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 74267-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 22 Aug 2003 07:01:38 -0300 (ADT)
Received: from rtlocal.trade-india.com (unknown [61.16.154.82])
	by svr1.postgresql.org (Postfix) with SMTP id 32786D1BA89
	for <pgsql-sql@postgresql.org>; Fri, 22 Aug 2003 07:01:33 -0300 (ADT)
Received: (qmail 9043 invoked from network); 22 Aug 2003 10:12:44 -0000
Received: from unknown (HELO trade-india.com) (unknown)
	by unknown with SMTP; 22 Aug 2003 10:12:44 -0000
From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: pgsql-sql@postgresql.org
Subject: Joined deletes but one table being a subquery.
Date: Fri, 22 Aug 2003 15:31:13 +0530
User-Agent: KMail/1.5.1
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200308221531.13782.mallah@trade-india.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/268
X-Sequence-Number: 14884


Hi Folks,

DELETE  from eyp_listing where userid=t_a.userid and category_id=t_a.category_id;
such queries work perfectly.

but if t_a is a subquery how to accomplish the delete.

Regds
Mallah.