Quaint Query for Quick Bit Flip

Written by Jamie McBurney
Posted on Oct 3, 2012 at 10:57 AM

How's this for the a super simple way to flip a bit field from 1 to 0 and back:

UPDATE myTable
SET myBitField = coalesce(myBitField,0) ^ 1
WHERE myPrimaryKey = 'uniqueIDHere'

I'm in love.

Share and Subscribe:

Tags:

Name: Brad Anderson
Posts: 146
Last Post: February 18, 2020
Show Brad's Posts

Name: Christine Votruba
Posts: 26
Last Post: January 17, 2020
Show Christine's Posts

Name: Rob Matlow
Posts: 85
Last Post: December 20, 2019
Show Rob's Posts

Name: Ryan Covert
Posts: 48
Last Post: July 26, 2019
Show Ryan's Posts

Name: Sean Sanderson
Posts: 63
Last Post: July 23, 2019
Show Sean's Posts

Name: Matt Stern
Posts: 4
Last Post: July 16, 2019
Show Matt's Posts

Name: Sean Legge
Posts: 1
Last Post: June 28, 2019
Show Sean's Posts

Name: Sean McParland
Posts: 17
Last Post: June 28, 2019
Show Sean's Posts

Name: Todd Hannigan
Posts: 47
Last Post: November 13, 2018
Show Todd's Posts