GENERAL - [How to check if the array contains the element.]

From: VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: GENERAL - [How to check if the array contains the element.]
Date: 2017-04-26 11:24:25
Message-ID: CA+iwz4micr=cjNfikcJJEkMypXfqPwRbKt+1vd28yTUCZ0059Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

How do i check if any one element of one array exists in another array.
Eg:
array1 = [1,2,3,4]
array2 = [1,4,5,7]
Now i expect the result as true even if any one element matches from
array2 in array1.

Any help would be appreciated.

Thank you.

--
Regards :
Venktesh Guttedar.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2017-04-26 11:33:03 Re: GENERAL - [How to check if the array contains the element.]
Previous Message Ron Ben 2017-04-26 10:36:22 Re: How to upgrade PostgreSQL minor version?