Re: Consulta con Condicionales

"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

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support