PostgreSQL select items of an array that are not in another array

Question

PostgreSQL table with two integer array columns, say a = [1,2,3,4] and b = [1,2,3,4,5,6]. The items of b that are not in a are 5,6, so as a query result I want an array [5,6].

How to achieve this in PostgreSQL?

Possible duplicate of Postgres - Function to return the intersection of 2 ARRAYs? — Gholamali Irani
– Gholamali Irani, Commented Dec 13, 2017 at 19:07
see: intarray Operators on postgresql.org/docs/current/static/intarray.html — Gholamali Irani
– Gholamali Irani, Commented Dec 13, 2017 at 19:11
so simple... with intarray extension installed, its simply select a-b — Jochen Schwarze
– Jochen Schwarze, Commented Dec 13, 2017 at 19:16

Jochen Schwarze · Accepted Answer · 2018-03-23 10:20:22Z

3

with intarray extension installed, one may simply select a-b, cp. https://www.postgresql.org/docs/current/static/intarray.html

answered Mar 23, 2018 at 10:20

Jochen Schwarze

3129 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL select items of an array that are not in another array

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