Postgres Pro
Downloads
Home   >   mailing lists

'group by day' possible? - Mailing list pgsql-general

From elwood@agouros.de (Konstantinos Agouros)
Subject 'group by day' possible?
Date
Msg-id elwood.996787047@news.agouros.de
Whole thread Raw
Responses Re: 'group by day' possible?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Points, Circles, Indexes, and query-by-Radius?
Next
From: "Jim Ballard"
Date:
Subject: timestamp with time zone