Postgres Pro
Downloads
Home   >   mailing lists

Re: query that needs two nested queries, is this the best - Mailing list pgsql-general

From Mark Harrison
Subject Re: query that needs two nested queries, is this the best
Date
Msg-id 44525116.8000108@pixar.com
Whole thread Raw
In response to Re: query that needs two nested queries, is this the best  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Installing PostgreSQL on Win 2003 R2 64-bit
Next
From: Robert Treat
Date:
Subject: Re: Alternative for vacuuming queue-like tables