From: Adam Sherman <adam@tritus.ca>
To: pgsql-sql@postgresql.org
Cc: Josh Berkus <josh@agliodbs.com>
Subject: Re: Locating all Children given Set of Parents
Date: Tue, 13 May 2003 13:50:43 -0400
Message-ID: <195300000.1052848243@saturn> (raw)
In-Reply-To: <200305130947.46844.josh@agliodbs.com>
References: <184690000.1052842782@saturn>
<200305130947.46844.josh@agliodbs.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adam@tritus.ca, josh@agliodbs.com
Subject: Re: Locating all Children given Set of Parents
In-Reply-To: <195300000.1052848243@saturn>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox