Home > mailing lists

Re: Bitfields always atomic? Other way to store attributes? - Mailing list pgsql-sql

From	TJ O'Donnell
Subject	Re: Bitfields always atomic? Other way to store attributes?
Date	March 28, 2006 20:55:17
Msg-id	1066.209.223.166.104.1143582901.squirrel@www.gnova.com Whole thread Raw
In response to	Bitfields always atomic? Other way to store attributes? (Bryce Nesbitt <bryce1@obviously.com>)
List	pgsql-sql

Tree view

> If I have two threads modifying the same "bit" field:
>     thread1=> update table set bf=bf | '01000'
>     thread2=> update table set bf=bf | '10000'
> Will this operation always be safe (e.g. result in bf='11000')?  Or

Won't this always result in bf='11xxx', depending on the
original values of bf?

TJ
www.gnova.com

pgsql-sql by date:

From: "Fay Du"
Date: 28 March 2006, 17:33:22
Subject: Re: Update question

From: "Owen Jacobson"
Date: 28 March 2006, 20:59:52
Subject: Re: Bitfields always atomic? Other way to store attributes?

Re: Bitfields always atomic? Other way to store attributes? - Mailing list pgsql-sql

Previous

Next