I have a table with time stamps in it . These timestamp represent a event count.
I just wanted to know how could I query such that I get a count of
event per hour.
Table structure is
my_table(id serial, time_event timestamp,event varchar(200));
I want to do something like
select count(id) from my_table where time_event in (every 1 hour);
Any pointers / help would be appreciated
With Best Regards,
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2006-04-11 20:54:06|
|Subject: Re: Indexes slower when used in decending vs. ascending order? |
|Previous:||From: Alasdair Young||Date: 2006-04-11 20:40:52|
|Subject: Re: Indexes slower when used in decending vs. ascending|