Postgres Pro
Downloads
Home   >   mailing lists

Re: returning row numbers in select - Mailing list pgsql-general

From Tom Lane
Subject Re: returning row numbers in select
Date
Msg-id 13151.1078955425@sss.pgh.pa.us
Whole thread Raw
In response to Re: returning row numbers in select  (Randall Skelton <skelton@brutus.uwaterloo.ca>)
Responses Re: returning row numbers in select
List pgsql-general
Tree view 
Randall Skelton <skelton@brutus.uwaterloo.ca> writes:
> Correction, I don't want to simply get the nth row, I want all rows
> that are divisible by n.  Essentially, the timestamp is at a regular
> interval and I want a way of selecting rows at different sampling
> intervals.

Couldn't you code this as a WHERE test on the timestamp?

            regards, tom lane

pgsql-general by date:

Previous
From: Josué Maldonado
Date:
Subject: Organize tables in schemas
Next
From: "Vidyasagara Guntaka"
Date:
Subject: Functions / Prepared statements