Re: plpgsql - sorting result set

Поиск
Список
Период
Сортировка
От Robert Gobeille
Тема Re: plpgsql - sorting result set
Дата
Msg-id 228D1784-957E-4F2F-BE53-541705759539@hp.com
обсуждение исходный текст
Ответ на Re: plpgsql - sorting result set  ("Merlin Moncure" <mmoncure@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Richard Broersma"
Дата:
Сообщение: psql \df+ [pattern] with overloaded functions
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: on delete cascade slowing down delete