Re: [GENERAL] plpgsql - sorting result set

2008-08-21 Thread Robert Gobeille
On Aug 21, 2008, at 6:21 AM, Merlin Moncure wrote: You can always pass the order by clause (or hardcode it) into the execute statement. Also if you are using 8.3 you may want to check out to the new improvements to 'execute'...using. Hi Merlin, I can't use an order by on the execute, because

Re: [GENERAL] plpgsql - sorting result set

2008-08-21 Thread Merlin Moncure
On Thu, Aug 21, 2008 at 1:03 AM, Bob Gobeille <[EMAIL PROTECTED]> wrote: > On Aug 20, 2008, at 10:11 PM, Gobeille, Robert wrote: >> On Aug 20, 2008, at 7:37 PM, Merlin Moncure wrote: >>> On Wed, Aug 20, 2008 at 7:20 PM, Robert Gobeille Is it possible to sort a result set in plpgsql?

Re: [GENERAL] plpgsql - sorting result set

2008-08-20 Thread Bob Gobeille
On Aug 20, 2008, at 10:11 PM, Gobeille, Robert wrote: On Aug 20, 2008, at 7:37 PM, Merlin Moncure wrote: On Wed, Aug 20, 2008 at 7:20 PM, Robert Gobeille <[EMAIL PROTECTED]> wrote: Is it possible to sort a result set in plpgsql? That is, after building up the result set with RETURN NEXT fr

Re: [GENERAL] plpgsql - sorting result set

2008-08-20 Thread Bob Gobeille
On Aug 20, 2008, at 7:37 PM, Merlin Moncure wrote: On Wed, Aug 20, 2008 at 7:20 PM, Robert Gobeille <[EMAIL PROTECTED]> 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

Re: [GENERAL] plpgsql - sorting result set

2008-08-20 Thread Merlin Moncure
On Wed, Aug 20, 2008 at 7:20 PM, Robert Gobeille <[EMAIL PROTECTED]> 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 iss