Postgres Pro
Downloads
Home   >   mailing lists

Re: Joined deletes but one table being a subquery. - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Joined deletes but one table being a subquery.
Date
Msg-id 3F45EF2E.7060709@klaster.net
Whole thread Raw
In response to Joined deletes but one table being a subquery.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: Joined deletes but one table being a subquery.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-sql
Tree view 
> 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.
What kind of subquery it is? Exist/Not exist doesn't work?

Regards,
Tomasz Myrta

pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Joined deletes but one table being a subquery.
Next
From: Michele Bendazzoli
Date:
Subject: Bug on parameter bigint in PL/PGSQL