Re: Is this query possible in PostgreSQL ?

Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> SELECT * from some_table WHERE MOD(some_row, :n) = 0;

> So this allows you to get every Xth result, like every 3rd row.  Wow,
> that is interesting.

s/interesting/useless/.  Every third row in what ordering?  And don't
tell me about ORDER BY, because WHERE conditions are processed before
ORDER BY.

            regards, tom lane