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
Re: CASE in ORDER BY clause |
Список | 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 по дате отправления: