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

On Wednesday 04 February 2004 06:24, CSN wrote:[color=blue]
> 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();[/color]

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