Re: plpgsql - sorting result set

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Robert Gobeille" <bob(dot)gobeille(at)hp(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql - sorting result set
Date: 2008-08-21 01:37:04
Message-ID: b42b73150808201837h4b46ea51h796422adc2c286d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 20, 2008 at 7:20 PM, Robert Gobeille <bob(dot)gobeille(at)hp(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2008-08-21 02:00:52 Re: function SETOF return type with variable columns?
Previous Message Tom Lane 2008-08-21 01:29:48 Re: order by x using varchar_pattern_ops