finding items with 0 rels for a 0 to many relationship

Поиск
Список
Период
Сортировка
От danmcb
Тема finding items with 0 rels for a 0 to many relationship
Дата
Msg-id 1182443322.597220.15080@p77g2000hsh.googlegroups.com
обсуждение исходный текст
Ответы Re: finding items with 0 rels for a 0 to many relationship
Список pgsql-general
Hi

I have two tables, say A and B,  that have a many-to-many
relationship, implemented in the usual way with a join table A_B.

How can I economically find all the rows in table A whose id's are not
in A_B at all (i.e. they have zero instances of B associated)?

Thanks

Daniel


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 8.2.3 PANIC with "corrupted item pointer"
Следующее
От: "Josh Tolley"
Дата:
Сообщение: Re: finding items with 0 rels for a 0 to many relationship