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