RETURN NEXT and reversing order

[CSN]

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/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Richard Huxton]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org