From: "boyd (remove_) tb_moore_@bealenet_.com" <HeWillRejoice@yahoo.com>
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US;
	rv:1.4) Gecko/20030624 Netscape/7.1
MIME-Version: 1.0
Subject: Re: max timestamp
References: <f7359f44.0402101014.77198f7b@posting.google.com>
In-Reply-To: <f7359f44.0402101014.77198f7b@posting.google.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 24
Message-ID: <qCaWb.19169$Gx1.13160@fe01.usenetserver.com>
Date: Tue, 10 Feb 2004 14:50:45 -0500
To: pgsql-sql@postgresql.org

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