Postgres Pro
Downloads
Home   >   mailing lists

Thread: intarray overlap (have elements in common) operator

intarray overlap (have elements in common) operator

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/functions-array.html
Description:

Hi 

How do i write below native query to JPA/Hibernate. (JPQL)

SELECT * FROM TABLE_NAME WHERE TABLE_COLUMN_ARRAY && '{1,2}'

Regards,
Anand S

Re: intarray overlap (have elements in common) operator

From
"David G. Johnston"
Date:
On Thursday, May 2, 2019, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/functions-array.html
Description:

Hi

How do i write below native query to JPA/Hibernate. (JPQL)

SELECT * FROM TABLE_NAME WHERE TABLE_COLUMN_ARRAY && '{1,2}'


This is not the correct forum for your question.  -general might get you a response but for client-side questions asking questions to that community specifically is a better bet.

David J.