RE: Combining two SELECTs - Mailing list pgsql-general

From Eric Jain
Subject RE: Combining two SELECTs
Date
Msg-id NCBBJFHBEGOIAHBCBNCLOEIECIAA.jain@gmx.net
Whole thread Raw
In response to Re: Combining two SELECTs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> By 7.2 or so, we hope to support sub-SELECTs in FROM, which'd let
> you do this along the lines of
>
>     SELECT host,COUNT(*) FROM (SELECT DISTINCT host, ...)
>         GROUP BY ...

That would be great. Would have come in handy quite a few times
already...


--
Eric Jain


pgsql-general by date:

Previous
From: Paulo Henrique Baptista de Oliveira
Date:
Subject: Redundant
Next
From: Tom Lane
Date:
Subject: Re: responses to licensing discussion