Helo
This is provided that the list is constant
SELECT * FROM subcampo sc JOIN campo c ON (c.codigo = sc.campo)
JOIN (values(245,1),(130,2), (240,3), (243,4), (246,5), (490,6),
(630,7), (730,8), (740,9)) as d(dato,orden) on (c.etiqueta =d.dato)
ORDRE BY d.orden
On Tue, Jun 19, 2012 at 2:31 PM, Martín Marqués <[email protected]>wrote:
> How can I order a result set by a special order of a column. For
> example, let's say I have this query
>
>
> SELECT * FROM subcampo sc JOIN campo c ON (c.codigo = sc.campo)
> WHERE c.etiqueta IN (245, 130, 240, 243, 246, 490, 630, 730, 740)
>
> Now I want to order the result set using c.etiqueta but with the order
> of the values as you see in the IN clause.
>
> How can I do that?
>
> --
> Martín Marqués
> select 'martin.marques' || '@' || 'gmail.com'
> DBA, Programador, Administrador
>
> --
> Sent via pgsql-general mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Cordialmente,
Ing. Hellmuth I. Vargas S.
Esp. Telemática y Negocios por Internet
Oracle Database 10g Administrator Certified Associate
