Fwd: Re: sum(bool)?

El Viernes 23 Febrero 2001 16:22, escribiste:
> hi there,
>
> i want to add up the "true" values of a comparison like
>
> sum(a>b)
>
> it just doesn't work like this
>
> any workaround?
>
> it is postgresql 7.0 under linux
>
> thanks
>
> olaf

I did exactly the same thing two months ago ....

I created this tiny function:

CREATE FUNCTION bool2int(bool) RETURNS integer
AS 'select (case when $1=true then 1 else 0 end)'
LANGUAGE 'sql';

You can do: sum(bool2int(a>b))

easy ??? ;-))

--
Fernando Moyano

Frase del día:
--------------
El medico me prohibio beber wiski, ahora lo congelo y me lo como!

(*) SymeX ==> http://symex.lantik.com
(*) WDBIL ==> http://wdbil.sourceforge.net
(*) Informate sobre LINUX en http://www.linux.org