Re: returning count(*) when it is > 1, else -1

Gerardo Herzig wrote:
>
> But it does a doble count(*) that i must avoid.
> I cant refer to the 'first' count like
> select case when (select count(*) from test where id=$1 ) AS total
> > 0 then total
> else -1
> end;

SELECT
CASE WHEN total >0 THEN total ELSE -1 END AS new_total
FROM (
SELECT count(*) AS total FROM test WHERE id=$1
) AS raw_total

--
Richard Huxton
Archonet Ltd