PostgreSQL check if array contains any element from left-hand array

by

Sure, use the && array-overlaps operator:

SELECT ARRAY[1,2] && ARRAY[1,3,4,7];

See array functions and operators.

Related Contents:

  1. Postgres NOT in array
  2. How to turn a json array into rows in postgres
  3. Get Nth element of an array that returns from “string_to_array()” function
  4. Appending (pushing) and removing from a JSON array in PostgreSQL 9.5+
  5. Loop over array dimension in plpgsql
  6. How to apply a function to each element of an array column in Postgres?
  7. Iterating over integer[] in PL/pgSQL
  8. Inserting array values
  9. Remove array values in pgSQL
  10. Postgres integer arrays as parameters?
  11. in postgres select, return a column subquery as an array?
  12. Cannot INSERT: ERROR: array value must start with “{” or dimension information
  13. Adding value to Postgres integer array
  14. How to iterate a loop with index and element in Swift
  15. How to initialize an array in Kotlin with values?
  16. Print array elements on separate lines in Bash?
  17. Read lines from a file into a Bash array [duplicate]
  18. How to split a delimited string in Ruby and convert it to an array?
  19. Declare a constant array
  20. Swift Dictionary: Get values as array
  21. Change values while iterating
  22. Declare and Initialize String Array in VBA
  23. How can I store the “find” command results as an array in Bash
  24. Removing duplicate values from a PowerShell array
  25. What Haskell representation is recommended for 2D, unboxed pixel arrays with millions of pixels?
  26. How do I make a exact duplicate copy of an array?
  27. mongodb find by multiple array items
  28. TypeScript and array reduce function
  29. How to unload a ByteArray using Actionscript 3?
  30. How to rearrange item of an array to new position in Swift?
  31. Find the Smallest Integer Not in a List
  32. Changing The value of struct in an array
  33. Iterate over two arrays simultaneously
  34. Equals method for data class in Kotlin
  35. Most idiomatic way to select elements from an array in Golang?
  36. Creating an Array from a Range in VBA
  37. MongoDB – Query on the last element of an array?
  38. Printing array in Scala
  39. How to find if an array contains a string [duplicate]
  40. Typescript – Sort strings descending
  41. Shell Script: correct way to declare an empty array
  42. In Swift, what’s the cleanest way to get the last two items in an Array?
  43. How to merge all integer arrays from all records into single array in postgres
  44. TWIG how to get the first item from the array
  45. Creating an extension to filter nils from an Array in Swift
  46. How can I convert a buffer of a slice of bytes (&[u8]) to an integer?
  47. How to extract a particular element from an array in BASH?
  48. STArray documentation for newbies and State/ST related questions
  49. Convert an array into an index hash in Ruby
  50. When should I use indexed arrays of OpenGL vertices?

Leave a Comment