--- In firebird-support@yahoogroups.com, "Max Renshaw-Fox" <maxrf@...>
wrote:

>
> Is it not possible to:
>
> SELECT * FROM GET_DATA(IN_USER_ID) ORDER BY IN_ORDER_BY
>
> ie order outside the SP?

I would suggest that your suggestion would be possible, except it
would not be able to perform an indexed walk that may be possible
inside the SP. You should get the right data but there *may* be a
performance penalty. Then again, an in memory sort is often faster
than an indexed walk.

Adam