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. <pre class="prettyprint"><code>array[1,2,3] NOT && array[4,5] </code></pre> Any ideia would be appreciate.

Just another try and I got this working <pre class="prettyprint"><code>SELECT NOT(ARRAY[1,2,3] && ARRAY[4,5]) </code></pre>

Is there inverse overlap (&&) to array in 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.

337

asked Feb 26 '16 13:02

Just another try and I got this working

SELECT NOT(ARRAY[1,2,3] && ARRAY[4,5])

answered Oct 21 '22 08:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!