Re: Joined deletes but one table being a subquery.

Поиск
Список
Период
Сортировка
От Tomasz Myrta
Тема Re: Joined deletes but one table being a subquery.
Дата
Msg-id 3F45EF2E.7060709@klaster.net
обсуждение исходный текст
Ответ на Joined deletes but one table being a subquery.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Ответы Re: Joined deletes but one table being a subquery.
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Joined deletes but one table being a subquery.
Следующее
От: Michele Bendazzoli
Дата:
Сообщение: Bug on parameter bigint in PL/PGSQL