Subject Re: [firebird-support] Select records by their position
Author Alexandre Benson Smith
Magno Machado wrote:
>> Yes you are wrong. As I and others have already answered you tables are
>> unordered sets of rows. There is no position. Postion comes to play on
>> your
>> client side when you see your data in some nice grid
> Ok.
> So, how does first/skip works?
I am not talking about implementation details (since I don't know FB
code) but something on this line:

select first X skip Y from foo

In the fetch loop, skip (does not return to the client) the Y first ROWS
and return the X next rows, stop as soon as X records are returned or
the end of the result set are reached.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil