Обсуждение: RETURN NEXT and reversing order

Is it possible to reverse the order of items returned
from a plpgaql function that uses RETURN NEXT? (order
by col isn't what I want)

select * from my_function();


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

On Wednesday 04 February 2004 06:24, CSN wrote:
> Is it possible to reverse the order of items returned
> from a plpgaql function that uses RETURN NEXT? (order
> by col isn't what I want)
>
> select * from my_function();

I don't think ORDER BY can operate without a column to refer to. Looks like
you'll need a parameter on the function so it runs itself backwards.
--
  Richard Huxton
  Archonet Ltd