Received: from nts1.rtp.epa.gov (nts1.rtp.epa.gov [134.67.208.208]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA32096 for ; Tue, 18 Jan 2000 13:47:47 -0500 (EST) (envelope-from volpe.mark@epamail.epa.gov) Received: from epamail.epa.gov (IDENT:mvs@wolfpack.rtpnc.epa.gov [134.67.136.18]) by nts1.rtp.epa.gov (8.9.3/8.9.3) with ESMTP id NAA18724; Tue, 18 Jan 2000 13:50:39 -0500 (EST) Sender: mvs@nts1.rtp.epa.gov Message-ID: <3884B5BA.C1155D45@epamail.epa.gov> Date: Tue, 18 Jan 2000 13:49:30 -0500 From: Mark Volpe X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.9-27mdk i586) X-Accept-Language: en MIME-Version: 1.0 To: The Hermit Hacker , pgsql-sql@postgresql.org Subject: Re: [SQL] Ordering a date_part() query ... References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit INSERT INTO my_brain VALUES ('clue') :-) Whoops, Bruce's response reminded me, what I meant to say was ORDER BY "Summary - by Day/Hour"::datetime Mark The Hermit Hacker wrote: > > I have a query that looks like: > > SELECT ( date_part('month', stat_period) || '/' || > date_part('day', stat_period) || '/' || > date_part('year', stat_period) || ' ' || > date_part('hour', stat_period) || ':00:00' ) as "Summary - by > Day/Hour", > sum(impressions) as impressions, sum(click_thru) as click_thru > FROM banner_count > GROUP BY "Summary - by Day/Hour"; >