Greg Stark <[EMAIL PROTECTED]> writes:
> Clive Page <[EMAIL PROTECTED]> writes:
>> It would be nice if OFFSET could be implemented in some more efficient
>> way.
> You could do something like:
> select myfunc(mycol) from (select mycol from table limit 50 offset 1) as x;
Note that this won't
Clive Page <[EMAIL PROTECTED]> writes:
> SELECT myfunc(mycol) FROM table LIMIT 50 OFFSET 1 ;
> It looks as if OFFSET is implemented just be throwing away the results,
> until the OFFSET has been reached.
>
> It would be nice if OFFSET could be implemented in some more efficient
> way.
You