Re: simple update on boolean

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