On Tue, 3 Jan 2012, Tom Lane wrote:
> You can do that type of thing using subqueries, eg
>
> select ... from mytab
> where col = (select max(col) from mytab where ...)
Thanks, Tom. That's what I thought I needed.
> or if you don't mind a nonstandard construct, consider SELECT DISTINCT ON.
> There's an example of how to use that in the SELECT reference page
> (look for the weather-reports example). In any case you're going to
> have to consider what you want to have happen when there are multiple
> occurrences of the maximum value.
I'll look at that, too.
Much appreciated,
Rich