Re: Locating all Children given Set of Parents

From: Adam Sherman <adam(at)tritus(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Cc: Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: Locating all Children given Set of Parents
Date: 2003-05-13 17:50:43
Message-ID: 195300000.1052848243@saturn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-05-13 19:01:45 Re: Locating all Children given Set of Parents
Previous Message Adam Sherman 2003-05-13 17:46:50 Re: Locating all Children given Set of Parents