On Thu, 06 Dec 2007 13:38:31 +0100
Cedric Boudin <cedric@dreamgnu.com> wrote:
> It was indeed a forest problem.
> both:
>
> set bolean_column= not bolean_column
> and
> set bolean_column= case when bolean_column then 'f'::bool else
> 't'::bool end;
>
> do work perfectly.
What if boolean_column is NULL?
btw set bolean_column= not bolean_column works "as expected".
template1=# select (not 't'::boolean),(not 'f'::boolean),(not
NULL::boolean);
?column? | ?column? | ?column?
----------+----------+----------
f | t |
(1 riga)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it