From: | Miguel Rodríguez Penabad <penabad(at)gmail(dot)com> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
Cc: | Iván de Gyves López [[POD]] <biz004wm(at)gmail(dot)com>, pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Consulta con Condicionales |
Date: | 2008-06-16 07:42:35 |
Message-ID: | 95335e4e0806160042m5679b5e9w1ae92adc1f9326fa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
2008/6/15 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> "Iván de Gyves López [[POD]]" escribió:
>
>> -------------------------------------------------------------------------------------------------------------------------
>> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> SELECT COUNT( * ) AS cte FROM rde1 WHERE id = x AND group_id = y, CASE
>> WHEN cte > 0 THEN true ELSE false END AS result;
>
> Usa un subselect
>
> select cte, case when cte > 0 then true else false end as result from
> (select count(*) as cte from rde1 where id = x and group_id = y) as foo
>
¿Hacen falta el case y la subconsulta? Esto debería funcionar, ¿no?
select count(*), count(*) > 0 as result
from rde1 where id = x and group_id = y
Aunque seleccionar un número y si este número es >0 me parece
redundante, pero supongo que algún motivo habrá ...
Saludos
--
Miguel Rodríguez Penabad
From | Date | Subject | |
---|---|---|---|
Next Message | Rodriguez Fernando | 2008-06-16 11:16:02 | Re: nuevo release |
Previous Message | Jaime Casanova | 2008-06-16 04:25:07 | Re: Instalacion 8.3 y 8.2 en Windows XP |