'group by day' possible?

From: elwood(at)agouros(dot)de (Konstantinos Agouros)
To: pgsql-general(at)postgresql(dot)org
Subject: 'group by day' possible?
Date: 2001-08-02 21:18:19
Message-ID: elwood.996787047@news.agouros.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a table where I enter some data with a full flexed datetime. Is there
a _simple_ aggregate that I get the sum of entries for each day?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Ballard 2001-08-02 21:23:17 timestamp with time zone
Previous Message Tom Lane 2001-08-02 21:04:03 Re: Points, Circles, Indexes, and query-by-Radius?