Quick Links

Re: SELECT statement not working as intended

From:	John R Pierce <pierce(at)hogranch(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Re: SELECT statement not working as intended
Date:	2011-10-10 23:07:34
Message-ID:	4E937AB6.5010004@hogranch.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

On 10/10/11 3:45 PM, Rich Shepard wrote:
> As I asked Merlin, what is necessary to get the date that maximum
> quantity
> was recorded? A nested SELECT?

the complication is, there can be more than one date with the same
maximum value, so such a query would be ambiguous, or it would return
multiple rows.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Re: SELECT statement not working as intended at 2011-10-10 22:45:34 from Rich Shepard

Responses

Re: SELECT statement not working as intended at 2011-10-10 23:52:23 from Rich Shepard

Browse pgsql-general by date

	From	Date	Subject
Next Message	Bob Hatfield	2011-10-10 23:12:05	pg 8.3 replication causing corruption
Previous Message	Rich Shepard	2011-10-10 22:45:34	Re: SELECT statement not working as intended