Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group