How to query for Interval

Hi,


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,
Vishal Kashyap.
http://www.vishal.net.in