Re: Array intersection

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)