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:46:50
Message-ID: 194520000.1052848010@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)
> );

What is "pc_id" referring too?

Thanks,

A.

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adam Sherman 2003-05-13 17:50:43 Re: Locating all Children given Set of Parents
Previous Message Jamie Lawrence 2003-05-13 17:23:54 Re: N all-way relationship