Re: Array intersection

On Wed, 17 Oct 2007 11:12:27 -0500
"Rodrigo De León" <rdeleonp@gmail.com> wrote:

> On 10/17/07, Josh Trutwin <josh@trutwins.homeip.net> wrote:
> > nm - I just wrote a function - though curious if this is the most
> > effecient way:
>
> If you only want TRUE or FALSE, you can use '&&':
>
> t=# SELECT '{1,2}'::INT[] && '{2,3}'::INT[];
>  ?column?
> ----------
>  t
> (1 row)

Is that 8.2 or above?  I'm on 8.1.10:

psql=> SELECT '{1,2}'::INT[] && '{2,3}'::INT[];
ERROR:  operator does not exist: integer[] && integer[]
HINT:  No operator matches the given name and argument type(s). You
may need to add explicit type casts.

Josh