Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT statement not working as intended - Mailing list pgsql-general

From John R Pierce
Subject Re: SELECT statement not working as intended
Date
Msg-id 4E937AB6.5010004@hogranch.com
Whole thread Raw
In response to Re: SELECT statement not working as intended  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: SELECT statement not working as intended  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: SELECT statement not working as intended
Next
From: Bob Hatfield
Date:
Subject: pg 8.3 replication causing corruption