Andreas Tille <tillea(at)rki(dot)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