Postgres Pro
Downloads
Home   >   mailing lists

finding items with 0 rels for a 0 to many relationship - Mailing list pgsql-general

From danmcb
Subject finding items with 0 rels for a 0 to many relationship
Date
Msg-id 1182443322.597220.15080@p77g2000hsh.googlegroups.com
Whole thread Raw
Responses Re: finding items with 0 rels for a 0 to many relationship  ("Josh Tolley" <eggyknap@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.2.3 PANIC with "corrupted item pointer"
Next
From: "Josh Tolley"
Date:
Subject: Re: finding items with 0 rels for a 0 to many relationship