Achilleas Mantzios wrote: > Στις Friday 17 October 2008 15:11:10 ο/η Gerardo Herzig έγραψε: >> Richard Huxton wrote: >>> 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 >>> >> Pavel, Richard, you got it dudes! I have to say, that kinda 'reference >> before assingment' of "total" doesnt look logical to me. >> > > Then, both you and your boss need some SQL courses :) (no offense) > Hahaha none taken dude, youre absolutely right.
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql