Dynamic expressions set in "order by" clause

Поиск
Список
Период
Сортировка
От Sergey Konoplev
Тема Dynamic expressions set in "order by" clause
Дата
Msg-id c3a7de1f0711210748y56ca96f6sfec783b09e0ba230@mail.gmail.com
обсуждение исходный текст
Ответы Re: Dynamic expressions set in "order by" clause
Список pgsql-general
Hello,

I have a procedure which takes few arguments. The arguments must
affect expressions set of "order by" clause. For instance in one case
ordering must be performed by 1st, 2nd (desc) and 3rd fields but in
another by 3rd, 1st and 2nd fields.

Is there a way to manage it without using dynamic queries (execute
'...') and code duplicating?

--
Regards,
Sergey Konoplev

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

Предыдущее
От: "Rodrigo De León"
Дата:
Сообщение: Re: Table filter
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: loading a funtion script from a file