How to join to delete

Поиск
Список
Период
Сортировка
От Chris Velevitch
Тема How to join to delete
Дата
Msg-id b0a3bf780605012353u7799e90av2a2bb71b0eaec41e@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to join to delete  (Noel Faux <noel.faux@med.monash.edu.au>)
Re: How to join to delete  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
I'm using pg 7.4.5 on Win XP SP1.

I want to delete rows from a table B, but need to join it to another
table A in order to select the rows in B to be deleted.

Eg. Delete from A join B on (A.bk = B.bk) where A.ak = x;

but only delete rows from B.

How do I acheive this?


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: insert into a view?
Следующее
От: Don Y
Дата:
Сообщение: Return value (instead of reference) for user defined type