On Thu, 6 Dec 2007, A. Kretschmer wrote:
update table set bolean_column = set_it_to_its_inverse where fk = some_value;
I've used: update table set bolean_column = not boolean_column where fk = some_value; which has worked for me well. Daniel ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly