plpgsql - sorting result set

From: Robert Gobeille <bob(dot)gobeille(at)hp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql - sorting result set
Date: 2008-08-20 23:20:53
Message-ID: 9A38D00F-3696-4585-AB3B-AB390E8E59BD@hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,
Bob Gobeille
Hewlett Packard
Open Source Program Office

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill 2008-08-20 23:34:51 ADO/ODBC returns TEXT fields as Varchar, not LongVarChar
Previous Message Blakely, Jerel (Mission Systems) 2008-08-20 22:46:34 Re: Silent install 8.3 diiffers from 8.2