Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Sean DavisDate: 2005-02-22 15:44:40
Subject: Re: Function with record type as argument
Previous:From: Tom LaneDate: 2005-02-22 15:20:55
Subject: Re: Function with record type as argument

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group