Re: Query combination query. (fwd)

From: john-paul delaney <jp(at)justatest(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Query combination query. (fwd)
Date: 2005-02-22 15:26:16
Message-ID: Pine.LNX.4.44.0502221623220.13607-100000@angelico.justatest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2005-02-22 15:44:40 Re: Function with record type as argument
Previous Message Tom Lane 2005-02-22 15:20:55 Re: Function with record type as argument