Re: add, subtract bool type

Jeff Davis writes:

> I made some simple functions that create the operators + and - for any
> combination of int4's and bool's.
>
> The reasoning that propted this operator was that I wanted to use the
> following syntax in a query:
> SELECT *,((col_a == 'foo') + (col_b == 'bar')) as relevance WHERE
> relevance > 0;

You could also try

case when col_a = 'foo' then 1 else 0 end + case when col_b = 'bar' then 1
else 0 end

which is the usual way to "cast" booleans.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter