actually, wouldn't returning a rowid be a better option than first(x) or
whatever, that way the user can include the rowid in the where clause and do
whatever the hell they want selection wise? select * from blah where rowid
in (1,3,5,7,9)? I'd think this would be a better option than having it as an
aggregate style function.

> -----Original Message-----
> From: Peter Morris [mailto:pmorris@...]
> Sent: Thursday, 31 May 2001 7:17 AM
> To: ibdi
> Subject: [IBDI] Firebird 1
>
>
> I don't suppose there is a plan to enable Firebird V1 to return a range of
> rows ?
> 1 - 10, 11 - 20, 21 - 30 etc ?
>
> Just like a search engine would, otherwise I will have to do
> select * from MyTable where not ID in (Select ID from MyTable
> order by date)
> order by date
> Which would obviously be quite intensive.
>
> Pete
> ===
> http://www.HowToDoThings.com
>
>
>
> Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
> Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>