From: | Miguel Ortega <mortega(at)tc(dot)com(dot)ve> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: SELECT |
Date: | 2007-08-16 14:05:55 |
Message-ID: | 46C459C3.1030304@tc.com.ve |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola de nuevo!
Que mal vicio de escribir sin probar :D
>
> SELECT * FROM T1 WHERE c1 >= 'aaaaa' AND c1 <= 'eeee' AND 1=(SELECT
> count(c2) FROM T1 WHERE c1 >= 'aaaaa' AND c1 <= 'eeee');
Cree las tablas que diste... Si ejecuto esto:
SELECT * FROM T1 WHERE c1 >= 'aaaaa' AND c1 <= 'ccccc' AND 1=(
SELECT count(*) FROM (SELECT DISTINCT ON(c2) c2 FROM T1 WHERE c1 >=
'aaaaa' AND c1 <= 'ccccc') AS foo
);
no retorna nada...
Pero si ejecuto esto:
SELECT * FROM T1 WHERE c1 >= 'aaaaa' AND c1 <= 'bbbb' AND 1=(
SELECT count(*) FROM (SELECT DISTINCT ON(c2) c2 FROM T1 WHERE c1 >=
'aaaaa' AND c1 <= 'bbbb') AS foo
);
Devuelve los dos primeros registros...
Saludos!!!
No se si es óptimo o no... o siquiera responde tu pregunta... pero es
bonito practicar estos querys locos para que alguien en la lista te diga
una manera más elegante!!!
--
_________________________________________
Miguel A. Ortega B.
Analista de Sistemas y Soporte a Usuarios
<0416 - 642 12 26> / < mortega(at)tc(dot)com(dot)ve>
Technologies Consulting C.A.
From | Date | Subject | |
---|---|---|---|
Next Message | Miguel Ortega | 2007-08-16 15:23:38 | Permutar |
Previous Message | Miguel Ortega | 2007-08-16 13:53:42 | Re: SELECT |