On 10/17/07, Josh Trutwin <josh@xxxxxxxxxxxxxxxxxxx> wrote: > On Wed, 17 Oct 2007 11:12:27 -0500 > "Rodrigo De León" <rdeleonp@xxxxxxxxx> wrote: > > > On 10/17/07, Josh Trutwin <josh@xxxxxxxxxxxxxxxxxxx> 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: introduced in 8.2 merlin ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend