1

Consider the following table

id int lang_codes text[]
1 {eng,fre}
2 {eng}

I need to select all the rows from the table that intersect with the input array, but only when all the items in the lang_codes are present in the input array, e.g.:

  • if the input array contains [eng,fre,ger] then it returns all the rows
  • while [eng,ger] won't return the first record, because it needs both codes to be present in the input array.

I've tried the && operand, but it returns all the rows:

select * from my_table where lang_codes && ARRAY['eng','ger'];

From the other hand @> operand, returns only when array matches fully

Majesty
  • 2,097
  • 5
  • 24
  • 55

1 Answers1

1

The <@ operator should do the trick:

select * from my_table where lang_codes <@ ARRAY['eng','ger'];

SQL Fiddle

Frank Schmitt
  • 30,195
  • 12
  • 73
  • 107