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

Adam,

> > 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?

parent_child.id

Which column you use isn't important, just don't use "SELECT *"

--
-Josh BerkusAglio Database SolutionsSan Francisco