On Thu, 2004-11-04 at 14:15 -0500, Tom Lane wrote:
> If you don't mind using a Postgres-specific construct, SELECT DISTINCT ON
> works nicely for this. See the "weather reports" example in the SELECT
> reference page.
It took a few minutes for what you were suggesting to click, but now I
am completely blown away by that - its *so* much simpler.
Cheers
Nigel.
--
[ Nigel Metheringham Nigel(dot)Metheringham(at)InTechnology(dot)co(dot)uk ]
[ - Comments in this message are my own and not ITO opinion/policy - ]