Cedric Boudin wrote: > Most honourable members of the list, > > this is a simple one, but I can't find the solution ( probably a > forest/tree problem). > > update table set bolean_column = set_it_to_its_inverse where fk = > some_value; > > or join me in the dark forest > > cedric > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > 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. Thks for bringing me the light in the forest. working late isn't that effective !!! cedric ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
