On Tue, Feb 10, 2004 at 10:14:04 -0800,
Michael Sterling <stermic(at)gw(dot)co(dot)jackson(dot)mo(dot)us> wrote:
> i'm trying to get the max time stamp, from each day, of a range of
> dates, not just the max time stamp for the complete range dates but
> for each day.
SELECT DISTINCT ON can probably do what you want. Something like:
SELECT DISTINCT ON (timestamp::DATE) * FROM table ORDER BY timestamp DESC;
This won't produce any records for days where there are no timestamps.