From: Vincent Ladlad <vincentl@ntsp.nec.co.jp>
To: vincentl@ntsp.nec.co.jp
Subject: staggered query?
Date: Wed, 21 Apr 2004 10:53:16 +0800
Message-ID: <002901c4274b$cb7ace30$643b1cac@Titanium> (raw)
hi! im new to SQL, and i need to find a solution
to this problem:
i have a table with two columns, the first column
is of type timestamp.
the table contains hundreds of thousands of records.
i need to get all the entries/records at every 10 seconds
interval. example, given a table:
hh/mm/ss | data
---------------
00:00:00 1
00:00:01 2
00:00:02 3
00:00:03 4
00:00:04 5
00:00:05 6
00:00:06 7
00:00:07 8
..
..
my query should return:
00:00:10
00:00:20
00:00:30
(etc)
is this possible? if yes, how do i do it?
thanks!
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.484 / Virus Database: 282 - Release Date: 5/27/2003
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vincentl@ntsp.nec.co.jp
Subject: Re: staggered query?
In-Reply-To: <002901c4274b$cb7ace30$643b1cac@Titanium>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox