On Tue, 22 Feb 2005, Bruno Wolff III wrote:

> The standard way to do this is to use the max function and select the
> row that matches this value.
>
> However the nonstandard DISTINCT ON construct is a better way to go if
> you don't need to be portable.
>
Thanks Bruno... I'd like to combine this all into one single query, if
that's possible.

/j-p.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org