Re: CASE en ORDER BY

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: cDaniel GE <cdanielg(at)gmail(dot)com>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: CASE en ORDER BY
Date: 2014-02-12 03:14:45
Message-ID: 20140212031445.GI6342@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

cDaniel GE escribió:

> deuda_id = id_deuda
> order by case
> when modo =1 then fecha asc
> else fecha desc end;
> loop

Quizás
ORDER BY
WHEN modo = 1 THEN fecha ELSE -fecha END
ASC;

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda(at)postgresql(dot)org)
Para cambiar tu suscripción:
http://www.postgresql.org/mailpref/pgsql-es-ayuda

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message FRANCISCO JOSE PALAO VILLANUEVA 2014-02-12 11:41:00 Re: Query lenta
Previous Message Jaime Casanova 2014-02-11 23:43:52 Re: Query lenta