Re: How to query for Interval

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: How to query for Interval
Дата
Msg-id 20060411212624.84671.qmail@web31811.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на How to query for Interval  ("Vishal Kashyap " <vishalonlist@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: How to query for Interval
Следующее
От: Andre Majorel
Дата:
Сообщение: Re: Curses interface