Re: plpgsql - sorting result set

On Wed, Aug 20, 2008 at 7:20 PM, Robert Gobeille <bob.gobeille@hp.com> wrote:
> Is it possible to sort a result set in plpgsql?
>
> That is, after building up the result set with RETURN NEXT  from multiple
> queries, I'd like to sort the set before returning.
>
> I'm still using 8.1 if that is an issue.

Have you already ruled out:

select * from (select * from your_func()) order by something?

if so, why?
merlin