Edward W. Rouse wrote:
Oh, postgres 7.4 by the way.
The latest release there is 7.4.17 - make sure you're running that
revision. See the website for what bugs have been fixed.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 7:
On 5/24/07, Edward W. Rouse <[EMAIL PROTECTED]> wrote:
I have an audit table that I am trying to get a count of the number of
distinct entries per day by the external table key field. I can do a
select count(distinct(id)) from audit where timestamp >= '01-may-2007'
and get a total count. What
am Thu, dem 24.05.2007, um 14:49:47 -0400 mailte Edward W. Rouse folgendes:
> I have an audit table that I am trying to get a count of the number of
> distinct
> entries per day by the external table key field. I can do a
>
> select count(distinct(id)) from audit where timestamp >= '01-may-2007
I have an audit table that I am trying to get a count of the number of distinct
entries per day by the external table key field. I
can do a
select count(distinct(id)) from audit where timestamp >= '01-may-2007'
and get a total count. What I need is a way to group on each day and get a
count
