Re: Union

On 4/28/07, Victor Lopez <d01m01a2000(at)gmail(dot)com> wrote:
> Y vuelvo a mi pregunta ... ¿Que es mayor ... TRUE o FALSE ... para un ORDER BY?
>

postgres=# select * from (select true as col1 union all select false) as foo
order by col1 ;
col1
------
f
t
(2 rows)

postgres=# select * from (select true as col1 union all select false) as foo
order by col1 desc;
col1
------
t
f
(2 rows)

parece que true... en realidad te costaba tanto hacer la prueba?

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook