CASE in ORDER BY clause

Поиск
Список
Период
Сортировка
От Louis-David Mitterrand
Тема CASE in ORDER BY clause
Дата
Msg-id 20070706150904.GA19593@apartia.fr
обсуждение исходный текст
Ответы Re: CASE in ORDER BY clause  (Viatcheslav Kalinin <vka@ipcb.net>)
Re: CASE in ORDER BY clause  (Viatcheslav Kalinin <vka@ipcb.net>)
Список pgsql-general
Hi,

I am trying the following:

    critik=# select start_date from show_date order by case when start_date > CURRENT_DATE then start_date desc else
start_dateasc end; 
    ERROR:  syntax error at or near "desc"
    LINE 1: ...se when start_date > CURRENT_DATE then start_date desc else
    ...

If I remove the "desc" and "asc" then the quey is accepted but doesn't
do what I want.

OTOH if I try:

    critik=# select start_date from show_date order by start_date case when start_date > CURRENT_DATE then desc else
ascend; 
    ERROR:  syntax error at or near "case"
    LINE 1: ...ect start_date from show_date order by start_date case when ...

How can i order ASC or DESC depending on a condition?

Thanks,

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

Предыдущее
От: "Sibte Abbas"
Дата:
Сообщение: Re: DB crashed and duplicated template0 db
Следующее
От: David Fetter
Дата:
Сообщение: Re: Polymorphic delete help needed