Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there inverse overlap (&&) to array in Postgresql?

Tags:

postgresql

I have two arrays in postgresql and I would like to discover if they DO NOT overlap.

I've tried to use NOT with the operator, no success.

array[1,2,3] NOT && array[4,5]

Any ideia would be appreciate.

like image 337
Sandro Wiggers Avatar asked Feb 26 '16 13:02

Sandro Wiggers


Video Answer


1 Answers

Just another try and I got this working

SELECT NOT(ARRAY[1,2,3] && ARRAY[4,5])
like image 77
Sandro Wiggers Avatar answered Oct 21 '22 08:10

Sandro Wiggers