Bryce Nesbitt wrote:
Tom Lane wrote:
In this particular case you could say
... GROUP BY 1 ORDER BY 1;
ORDER BY n as a reference to the n'th SELECT output column is in the
SQL92 spec. (IIRC they removed it in SQL99, but we still support it,
and I think most other DBMSes do too.)
this should work,
#
SELECT date_trunc('day',endtime),count(*)
FROM eg_event where endtime = '2006-02-01' and endtime '2006-03-01'
GROUP BY 1
ORDER BY 1;
best regards,
Stefan
Am Donnerstag, 16. März 2006 06:18 schrieb Bryce Nesbitt:
I've got a working query:
stage=# SELECT
Tom Lane wrote:
In this particular case you could say
... GROUP BY 1 ORDER BY 1;
"ORDER BY n" as a reference to the n'th SELECT output column is in the
SQL92 spec. (IIRC they removed it in SQL99, but we still support it,
and I think most other DBMSes do too.) "GROUP BY n" is *not* in
this should work,
#
SELECT date_trunc('day',endtime),count(*)
FROM eg_event where endtime = '2006-02-01' and endtime '2006-03-01'
GROUP BY 1
ORDER BY 1;
hope this helps
best regards,
Stefan
Am Donnerstag, 16. März 2006 06:18 schrieb Bryce Nesbitt:
I've got a working query:
I've got a working query:
stage=# SELECT date_trunc('day',endtime),count(*)
FROM eg_event where endtime = '2006-02-01' and endtime '2006-03-01'
GROUP BY date_trunc('day',endtime)
ORDER BY date_trunc('day',endtime);
date_trunc | count
-+---
2006-02-01 00:00:00
Bryce Nesbitt [EMAIL PROTECTED] writes:
SELECT date_trunc('day',endtime),count(*)
FROM eg_event where endtime = '2006-02-01' and endtime '2006-03-01'
GROUP BY date_trunc('day',endtime)
ORDER BY date_trunc('day',endtime);
Is there a way to eliminate the ugly repeated use of