Re: returning row numbers in select

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: returning row numbers in select
Дата
Msg-id 13151.1078955425@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: returning row numbers in select  (Randall Skelton <skelton@brutus.uwaterloo.ca>)
Ответы Re: returning row numbers in select  (Randall Skelton <skelton@brutus.uwaterloo.ca>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Josué Maldonado
Дата:
Сообщение: Organize tables in schemas
Следующее
От: "Vidyasagara Guntaka"
Дата:
Сообщение: Functions / Prepared statements