am Thu, dem 06.12.2007, um 10:25:26 +0100 mailte Cedric Boudin folgendes: > 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;
test=# create table forrest (id int, b bool); CREATE TABLE test=*# insert into forrest values (1,'f'::bool); INSERT 0 1 test=*# insert into forrest values (2,'t'::bool); INSERT 0 1 test=*# update forrest set b = case when b then 'f'::bool else 't'::bool end; UPDATE 2 test=*# select * from forrest ; id | b ----+--- 1 | t 2 | f (2 rows) Okay? Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
