Re: returning count(*) when it is > 1, else -1 - Mailing list pgsql-sql

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