Re: Joined deletes but one table being a subquery.

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Joined deletes but one table being a subquery.
Date: 2003-08-22 10:23:42
Message-ID: 3F45EF2E.7060709@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michele Bendazzoli 2003-08-22 11:59:54 Bug on parameter bigint in PL/PGSQL
Previous Message Rajesh Kumar Mallah 2003-08-22 10:01:13 Joined deletes but one table being a subquery.