PostgreSQL how to use bitwise operator |=

Question

I want to execute the following update query at PostgreSQL db but it does not work and gives syntax error.

Query as follows

update wl_user set role_bitmask= role_bitmask|=1 where email='[email protected]'

Problem seems to be with |= operator, does anybody have idea how to use |= operator in PostgreSQL?

Following is the error.

[Err] ERROR:  operator does not exist: integer |= integer
LINE 1: ...pdate wl_user set role_bitmask=role_bitmask|=1 where ...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

Community · Accepted Answer · 2017-05-23 10:28:20Z

3

Instead of role_bitmask= role_bitmask|=1 you must use role_bitmask=role_bitmask|1 which also makes some sense if you think what |= does and what | does.

To clarify: PostgreSQL has a lot of operators and allow you to define new operators. But in your case this does not matter for two reasons:

The manual for UPDATE says about the syntax (abbreviated): UPDATE ... table ... SET column = { expression | DEFAULT }. This means, that the = is mandatory and not any of the normal operators. Therefore there is no |= and no &= .
Among all those extensible operators there is no assignment operator. Assignment is handled in a special way for each case. Have a look at this question for some hints.

Regarding your question: An expression like role_bitmask= role_bitmask|=1 make eyebrows raise in every language :-)

Summary: You have to use the long form ... SET column = colum | bitmask.

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered Oct 28, 2011 at 19:12

A.H.

66.8k16 gold badges98 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL how to use bitwise operator |=

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related