Re: Searching array for multiple items

On Wed, Jan 25, 2017 at 11:29 AM, Alex Magnum <magnum11200(at)gmail(dot)com> wrote:

> Hi,
> I can search an array with 1 = ANY('{1,3,4,7}'::int[])
>
> I need to check for one or multiple items in the array.
>
> e.g. '1,7,3' = ANY('{1,3,4,7}'::int[]
>
> I do need to check if
> a) all items exist in the array
> b) at least one item exists in the array
>
> Is there a an operator that allows me to do these two?
> Does the order of left and right side matter?
> Right now I have a small function but I guess there is a more efficient
> way.
>

Look on our contrib/intarray

>
> Thanks for any help.
>
> A
>
>
>