Re: simple update on boolean

Ivan Sergio Borgonovo wrote:
> On Thu, 06 Dec 2007 13:38:31 +0100
> Cedric Boudin <cedric(at)dreamgnu(dot)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)
>
If it was null before it has to be null afterwards (IMHO).
If you don't want to have null,
take care of it somewhere else but not here.

cedric