Richard Darst dijo [Tue, Jun 28, 2011 at 04:56:39PM -0400]: > And here is the code: > > BEGIN; > UPDATE person SET iban=NULL, bic=NULL, bank_name=NULL, account_owner=NULL; > COMMIT; > > To blank logs, too: > BEGIN; > UPDATE log.person SET iban=NULL, bic=NULL, bank_name=NULL, account_owner=NULL; > COMMIT; > > It might be wise for someone who claims to know SQL (not me) check > these. I'm also not sure if I missed something obvious here making > the code invalid...
Oh, and FWIW - your queries look sane. The BEGIN and COMMIT statements are not needed, but won't hurt. _______________________________________________ Debconf-team mailing list Debconf-team@lists.debconf.org http://lists.debconf.org/mailman/listinfo/debconf-team
