Comparing arrays in PostgreSQL

Question

I am attempting to determine if any item from a list of values is present in an array column in PostgreSQL.

SELECT * FROM data WHERE array IN (array)

I have this working using the && operator and a manually constructed array literal:

SELECT id, data FROM things WHERE '{"value", "other"}' && (array_column)

Is there a better way of accomplishing this?

Are you really using 9.2 already? (which is not yet released) — user330315
– user330315, Commented Jun 20, 2012 at 11:01

Szymon Lipiński · Accepted Answer · 2012-06-20 10:51:13Z

3

This is a quite good way, what do you mean by a better way?

There is one thing which could be done some other way, you can create the array using ARRAY[...] like this:

select ARRAY['a', 'b'] && '{"a", "c"}';

answered Jun 20, 2012 at 10:51

Szymon Lipiński

28.8k17 gold badges81 silver badges82 bronze badges

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

2 Comments

Is there any difference between the two versions?

In my case, I get a typing error when comparing using the ARRAY syntax