Re: if-clause to an exiting statement

On Tuesday 07 December 2010 3:58:46 am kobi.biton wrote:
> hi thanks for the reply I did look at the CASE statement however cannot
> seem to alter the returned row-count ...
>
> CASE WHEN (@@ROW-COUNT = 0) THEN
>
> [what do I write here?] @@ROW-COUNT = 1?
>
> END
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/if-clause-to-an-exiting-statement-t
>p3295519p3295641.html Sent from the PostgreSQL - general mailing list
> archive at Nabble.com.

See below:

test=> SELECT count(*) from bool_test ;
count
-------
33
(1 row)

test=> SELECT count(*) ,
case count(*) when 0
then 1
else
count(*)
end
from
bool_test ;

count | count
-------+-------
33 | 33
(1 row)

test=> SELECT count(*) ,
case count(*) when 0
then 1
else
count(*)
end
from
bool_test
where
ifd=0;

count | count
-------+-------
0 | 1
(1 row)

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com