Ivan Sergio Borgonovo wrote: > 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) > 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
