Re: RETURN NEXT and reversing order

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: RETURN NEXT and reversing order
Дата
Msg-id 200402040953.13664.dev@archonet.com
обсуждение исходный текст
Ответ на RETURN NEXT and reversing order  (CSN <cool_screen_name90001@yahoo.com>)
Список pgsql-general
On Wednesday 04 February 2004 06:24, CSN wrote:
> Is it possible to reverse the order of items returned
> from a plpgaql function that uses RETURN NEXT? (order
> by col isn't what I want)
>
> select * from my_function();

I don't think ORDER BY can operate without a column to refer to. Looks like
you'll need a parameter on the function so it runs itself backwards.
--
  Richard Huxton
  Archonet Ltd

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

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Transfer database tables to a schema
Следующее
От: Christian Traber
Дата:
Сообщение: Transaction end on error