Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] GENERAL - [How to check if the array contains the element.] - Mailing list pgsql-general

From VENKTESH GUTTEDAR
Subject [GENERAL] GENERAL - [How to check if the array contains the element.]
Date
Msg-id CA+iwz4micr=cjNfikcJJEkMypXfqPwRbKt+1vd28yTUCZ0059Q@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] GENERAL - [How to check if the array contains theelement.]  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Ron Ben
Date:
Subject: Re: [GENERAL] How to upgrade PostgreSQL minor version?
Next
From: Andreas Kretschmer
Date:
Subject: Re: [GENERAL] GENERAL - [How to check if the array contains theelement.]