Setting a bit of bytea column using Postgresql

Question

I have a table which has a column of type bytea. I want to update it and set 76th bit as 1. What query should I use ?

Laurenz Albe · Accepted Answer · 2016-12-15 09:59:53Z

2

To change the 42nd bit to 1, you could use

UPDATE tab
SET binval = set_bit(binval, 41, 1)
WHERE ...

Note that you may be faster with such operations (but waste space) if you change the column to EXTERNAL instead of EXTENDED storage (see the TOAST documentation).

answered Dec 15, 2016 at 9:59

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BeginnersSake Over a year ago

Thanks a lot Laurenz

Collectives™ on Stack Overflow

Setting a bit of bytea column using Postgresql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related