| From: | Robert Gobeille <bob(dot)gobeille(at)hp(dot)com> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: plpgsql - sorting result set |
| Date: | 2008-08-21 16:35:25 |
| Message-ID: | 228D1784-957E-4F2F-BE53-541705759539@hp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 I'm trying to order
the results from multiple executes (the executes are in a loop). For
now, I've done the select * from (select * from myfunc()) order by
that you originally suggested. Thank you for that.
Bob
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2008-08-21 17:06:32 | on delete cascade slowing down delete |
| Previous Message | Richard Broersma | 2008-08-21 16:18:42 | psql \df+ [pattern] with overloaded functions |