Michael Sterling 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.
I don't trust the news client I was using. So will answer again from
the Netscape version; This worked for me:
I have a table, sis, with schema: Table "sis" Column | Type | Modifiers
--------+--------------------------+----------- time | timestamp with time zone | stat10 | integer |
ipf10 | real | ipf30 | integer |
select date_part ( 'doy',time ) as jday, max ( time ) from sis group by jday
(doy means day of year, which I called jday)
Boyd