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; >
I am usually a newbie around here, but this is one that I can answer :-) update table set boolean_column = not boolean_column where fk = some_value HTH Frank Millman ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
