Re: Array intersection

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

> On 10/17/07, Josh Trutwin <josh(at)trutwins(dot)homeip(dot)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