Re: Searching array for multiple items

[Oleg Bartunov <obartunov@xxxxxxxxx>]

On Wed, Jan 25, 2017 at 11:29 AM, Alex Magnum <magnum11200@xxxxxxxxx> 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