Re: max timestamp

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