Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA78449 for ; Sun, 20 Feb 2000 20:06:01 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id UAA16612; Sun, 20 Feb 2000 20:05:45 -0500 (EST) To: M.Mazurek@poznan.multinet.pl cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] group by date_part In-reply-to: References: Comments: In-reply-to M.Mazurek@poznan.multinet.pl message dated "Sun, 20 Feb 2000 23:33:46 +0000" Date: Sun, 20 Feb 2000 20:05:45 -0500 Message-ID: <16609.951095145@sss.pgh.pa.us> From: Tom Lane M.Mazurek@poznan.multinet.pl writes: > select count (*) from stats group by date_part('dow',data::datetime_; > I get everthing sortded just as I wanted to, but how can I ad another > column to know which dow it is? select date_part('dow',data::datetime), count(*) from stats group by date_part('dow',data::datetime); regards, tom lane