Received: from hesketh.net (wasabi-eth0-1.hesketh.net [216.27.10.31]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2LKJTt39034 for ; Wed, 21 Mar 2001 15:19:29 -0500 (EST) (envelope-from brent@rcfile.org) Received: from colo.rcfile.org (rdu25-28-152.nc.rr.com [24.25.28.152]) by hesketh.net (8.9.3/8.9.3) with ESMTP id PAA20208; Wed, 21 Mar 2001 15:19:28 -0500 X-Received-From: brent@rcfile.org X-Delivered-To: pgsql-sql@postgresql.org Received: (from brent@localhost) by colo.rcfile.org (8.11.3/8.11.3) id f2LKK3x01238; Wed, 21 Mar 2001 15:20:03 -0500 (EST) (envelope-from brent) Date: Wed, 21 Mar 2001 15:20:03 -0500 From: Brent Verner To: Peter Morgan Cc: pgsql-sql@postgresql.org Subject: Re: Toggle a Bit type ie not field Message-ID: <20010321152003.B1083@rcfile.org> References: <998ntm$1n41$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <998ntm$1n41$1@news.tht.net>; from mash@daffodil.uk.com on Tue, Mar 20, 2001 at 11:07:22PM -0000 X-Archive-Number: 200103/424 X-Sequence-Number: 2092 On 20 Mar 2001 at 23:07 (-0000), Peter Morgan wrote: | Here's the SP that toggles a Bit datatype. How would I make it comething | like | ??? | update pcpmanufacturers set def = not (def) where ManufID = @ManufID update pcpmanufacturers set def=(1-def) where ManufID=@ManufID; hth. brent -- - - - - - - - -=( d a m o n b r e n t v e r n e r )=- - - - - - - - - c e r t i f i e d n o s o u r c o p h o b i c