Re: How to query for Interval - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: How to query for Interval
Date
Msg-id 20060411212624.84671.qmail@web31811.mail.mud.yahoo.com
Whole thread Raw
In response to How to query for Interval  ("Vishal Kashyap " <vishalonlist@gmail.com>)
List pgsql-novice
This thread might be useful to you also.

http://archives.postgresql.org/pgsql-sql/2006-04/msg00014.php

Regards,

Richard

--- Vishal Kashyap  <vishalonlist@gmail.com> wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>


pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: How to query for Interval
Next
From: Andre Majorel
Date:
Subject: Re: Curses interface