From: | Vegeta <vegeta(at)cuaima(dot)ica(dot)luz(dot)ve> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | [GENERAL] Help with query (fwd) |
Date: | 1999-11-05 13:45:52 |
Message-ID: | Pine.LNX.4.05.9911050944330.27603-100000@cuaima.ica.luz.ve |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
---------- Forwarded message ----------
Date: Fri, 5 Nov 1999 09:35:25 -0400 (VET)
From: Vegeta <vegeta(at)cuaima(dot)ica(dot)luz(dot)ve>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with query
Dear list members:
I am new to the list and to SQL. I am using PostgreSQL 6.4.2 on Linux and
want to do the following query:
Given a table "works" with fields "idworker" (int4) and "timeofwork"
(datetime), i want to have a query who has the number of hours worked by
each "worker" in the form:
idworker hoursworked
I tried with:
SELECT idworker, COUNT(DISTINCT int8(timeofwork)/3600) as hoursworked
FROM works
GROUP BY idworker
but pgsql does not accept the DISTINCT inside the count (I read in a book
that there are some RDBMS that do accept it).
Is there another way to acomplish this?
Do I need to create a user-defined aggregate? If so, how should I do it?
Thanks in advance,
Guido Urdaneta
PS: Sorry for my bad english
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff MacDonald | 1999-11-05 14:30:34 | Stored Procedures |
Previous Message | Vegeta | 1999-11-05 13:35:25 | Help with query |