Postgres Pro
Downloads
Home   >   mailing lists

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

From Adam Sherman
Subject Re: Locating all Children given Set of Parents
Date
Msg-id 195300000.1052848243@saturn
Whole thread Raw
In response to Re: Locating all Children given Set of Parents  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Tree view 
On 05/13/03 09:47:46 -0700 Josh Berkus wrote:

> Select children.*
> from children where exists (select pc_id
>     from parent_child
>     where pc.child_id = children.id
>     and pc.parent_id IN ($parent_id_list)
>     );

Great, that works fine.

pc_id is not important.

Thanks for your quick help!

A.

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

pgsql-sql by date:

Previous
From: Adam Sherman
Date:
Subject: Re: Locating all Children given Set of Parents
Next
From: Josh Berkus
Date:
Subject: Re: Locating all Children given Set of Parents