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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
