Re: plpgsql - sorting result set - Mailing list pgsql-general

From Merlin Moncure
Subject Re: plpgsql - sorting result set
Date
Msg-id b42b73150808201837h4b46ea51h796422adc2c286d@mail.gmail.com
Whole thread Raw
In response to plpgsql - sorting result set  (Robert Gobeille <bob.gobeille@hp.com>)
Responses Re: plpgsql - sorting result set
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: order by x using varchar_pattern_ops
Next
From: "Merlin Moncure"
Date:
Subject: Re: function SETOF return type with variable columns?