Postgres Pro
Downloads
Home   >   mailing lists

Locating all Children given Set of Parents - Mailing list pgsql-sql

From Adam Sherman
Subject Locating all Children given Set of Parents
Date
Msg-id 184690000.1052842782@saturn
Whole thread Raw
Responses Re: Locating all Children given Set of Parents  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Tree view 
I have three tables: parents, children & parent_child_mm.

(So Parents and Children are in a Many-to-Many relationship.)

Given a set of Parents, say 1, 2 & 3, how do I retrieve all children in an 
efficient manner? (I want each child to appear only once.)

Thanks,

A.

--
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819

pgsql-sql by date:

Previous
From: "Ryan"
Date:
Subject: N all-way relationship
Next
From: chester c young
Date:
Subject: Re: N all-way relationship