Re: Order by in stored functions

Andreas Tille <tillea@rki.de> writes:
> I've got the following error message:
> ERROR: function declared to return varchar returns multiple values in
> final retrieve

This is a bug that has already been fixed in current sources: the check
that makes sure your select produces only one varchar column is
mistakenly counting the hidden IdSort column that's needed to sort by.

I don't know of any good workaround in 7.0, short of patching the
erroneous code.  Have you thought about using a view, rather than a
function returning set?
        regards, tom lane