Subject Re: [firebird-support] whats the opposite of first?
Author Daniel Albuschat
2006/10/18, Helen Borrie <helebor@...>:
> At 11:25 AM 18/10/2006, you wrote:
> >Helen,
> >
> > > You want to return a descending set that has its rows in ascending
> > > order, don't you? :-) With derived table support in Fb 2.0, it is
> > > doable (if horrible!)
> >
> >Why do you say horrible?
> >
> >I have been using derived tables and they are dream!!!
>
> Erm, not that derived tables are horrible (they are not!) but
> recursive calls to SELECT FIRST to get the nth, followed by the
> n-1th, followed by the n-2nd...etc...that's what I call horrible
> (from a performance POV).

It's a sign that someone has programmed too much lisp in his life ;-)

--
eat(this); // delicious suicide