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 MAA06150 for ; Tue, 18 Jan 2000 12:43:57 -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 MAA14668; Tue, 18 Jan 2000 12:46:43 -0500 (EST) Sender: mvs@nts1.rtp.epa.gov Message-ID: <3884A6BE.41B2C9CB@epamail.epa.gov> Date: Tue, 18 Jan 2000 12:45:34 -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 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"; > Try appending ORDER BY "Summary - by Day/Hour"::date to your query. Mark