Re: Array intersection - Mailing list pgsql-general

From Rodrigo De León
Subject Re: Array intersection
Date
Msg-id a55915760710170912k34be231anf9b225ef7699699@mail.gmail.com
Whole thread Raw
In response to Re: Array intersection  (Josh Trutwin <josh@trutwins.homeip.net>)
Responses Re: Array intersection
List pgsql-general
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)

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Array intersection
Next
From: Josh Trutwin
Date:
Subject: Re: Array intersection