On Thu, 06 Dec 2007 13:38:31 +0100 Cedric Boudin <cedric@xxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
