From: Denis P Gohel <sqllist@coralindia.com>
To: pgsql-sql@postgresql.org
Subject: Re: staggered query?
Date: Wed, 21 Apr 2004 12:41:53 +0530
Message-ID: <003601c4276f$ecac8980$3332a8c0@DENIS> (raw)
Hi Try this..
SELECT Col1 , Col2
FROM yourtable
WHERE to_number(to_char(col1, 'SS'),'99') / 10 ) in
(10,20,30,40,50,00);
HTH
Denis
> ----- Original Message -----
> From: Vincent Ladlad <vincentl@ntsp.nec.co.jp>
> To: <vincentl@ntsp.nec.co.jp>
> Sent: Wednesday, April 21, 2004 8:23 AM
> Subject: [SQL] staggered query?
>
>
> > 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
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
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: sqllist@coralindia.com
Subject: Re: staggered query?
In-Reply-To: <003601c4276f$ecac8980$3332a8c0@DENIS>
* 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