Bryce Nesbitt wrote:
> 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
> must I wrap things in
> explicit transactions?
Each of these commands will be its own transaction if you don't
explicitly start one.
> My application is to give attributes to an address table. But maybe
> there is a better way?
Create 5 boolean fields.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/