By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,291 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,291 IT Pros & Developers. It's quick & easy.

RETURN NEXT and reversing order

P: n/a
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

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.