Thanks Josh,
I'll do that, I just wasn't sure if I was missing something obvious.
Jeremy
-----Original Message-----
From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
Sent: Thursday, February 19, 2004 2:29 PM
To: jer(at)highboard(dot)com; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] DISTINCT ON troubles
Jeremy,
> Am I just approaching this all wrong and need to create a temporary table
> and draw from that, or is there a way to salvage this query?
Think about using a subquery instead of the DISTINCT ON approach. I don't
think you can get what you want with DISTINCT ON.
A temporary table is not necessary.
--
-Josh Berkus
Aglio Database Solutions
San Francisco