RE: Combining two SELECTs

From: "Eric Jain" <jain(at)gmx(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: RE: Combining two SELECTs
Date: 2000-07-05 16:01:58
Message-ID: NCBBJFHBEGOIAHBCBNCLOEIECIAA.jain@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-07-05 16:27:57 Re: responses to licensing discussion
Previous Message James L. Hall 2000-07-05 15:32:56 pg respawning too fast