Re: Ordenar resultados complicados [Solucionado]

From: Carolina Román Salgado <rossyr(at)abulafia(dot)ciencias(dot)uchile(dot)cl>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Ordenar resultados complicados [Solucionado]
Date: 2009-10-13 16:44:06
Message-ID: 1255452246.31951.202.camel@swpx22.sw.ehu.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

On Mon, 2009-10-12 at 16:47 -0300, Alvaro Herrera wrote:
> Usa un solo CASE:
>
> ORDER BY
> CASE WHEN type = 'eventos' THEN publish_date
> WHEN type = 'noticias' THEN starting_date
> END;
>

Gracias, ¡funciona perfectamente!

--
Carolina Román Salgado http://nano-bio.ehu.es/~xavier/gallery
Registered Linux user number 40938 http://counter.li.org/

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Jaime Casanova 2009-10-13 18:10:36 Re: trigger bloquea tabla?
Previous Message Alvaro Herrera 2009-10-13 16:11:31 Re: trigger bloquea tabla?