DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=C6MNd6eogpfRUFzds0SaMyaqVjh/cF9n/DnmaHcLvFqV/YrVzO4lh4T0JXgHQn39pJN0wTFs25X0WK+gsVfcw5ICETsmex2ZylRjHDMjMa4UzooHbJQ4yJ2XdyWfYW2imoto3deE0HPltVEcyYbEv0qHrZiqmejiN+jRN4GHpPA=
	;
Message-ID: <20060911050129.13298.qmail@web31814.mail.mud.yahoo.com>
Date: Sun, 10 Sep 2006 22:01:29 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: where clause subqueries vs multiple rows results
To: James Cloos <cloos@jhcloos.com>, pgsql-sql@postgresql.org
In-Reply-To: <m3y7srm695.fsf@lugabout.jhcloos.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> I've a query which I'd have liked to word akin to:
> 
>   SELECT guid FROM child WHERE the_fkey =
>          ( SELECT id FROM parent WHERE name ~ 'some_regex' )
>          ORDER BY the_fkey, my_pkey;
> 
> I got around it by doing the SELECT id first, and then doing a SELECT
> guid for each row returned, appending the results together.
> 
> Can that be done in a single query, insead of 1+n queries?

select guid 
from child C join parent P
on (C.the_fkey = P.di)
Where P.name ~ 'some_regex'
order by C.the_fkey, P.my_pkey;

Perhaps this might work.