Bitwise Operator Postgres

Question

I have a table that contains binary values such as:

binaryid    description
1           description1
2           description2
4           description3
8           description4

And I have another table that contains values:

DBID BinaryTogether
1    15
1    12
1     6

With the bitwise operator I want to get a table that would contain the following:

DBID   BinaryTogether BitwiseResult
1      15             description1,description2,description3,description4
1      12             description3,description4
1       6             description2, description3

You asked exactly the same question a couple hours ago and deleted it. Again, have you tried anything or read the fine manual and not understood something? — mu is too short
– mu is too short, Commented Jun 1, 2016 at 20:45

Abelisto · Accepted Answer · 2016-06-01 20:42:35Z

1

You can join those tables using & bitwise operator and then aggregate descriptions using string_agg function. Here is example:

with 
  b(x,d) as (
    values
      (1,'description1'),
      (2,'description2'),
      (4,'description3'),
      (8,'description4')),
  p(y) as (
    values
      (15),
      (12),
      (6))
select
  y,
  string_agg(d,',')
from
  p join b on (x & y != 0)
group by
  y

answered Jun 1, 2016 at 20:42

Abelisto

15.8k3 gold badges38 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

Bitwise Operator Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related