Re: query that needs two nested queries, is this the best

From: Mark Harrison <mh(at)pixar(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: query that needs two nested queries, is this the best
Date: 2006-04-28 17:29:58
Message-ID: 44525116.8000108@pixar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton wrote:
> SELECT id FROM p4_versions WHERE
> (versionof, version) IN (SELECT id,headver FROM p4_files WHERE ...)

Ahh, just what I was looking for...

Thanks All!
Mark

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2006-04-28 17:52:14 Re: Alternative for vacuuming queue-like tables
Previous Message Bruno Wolff III 2006-04-28 17:04:16 Re: A few things on intervals