Array intersection

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Array intersection
Date: 2007-10-17 15:19:43
Message-ID: 20071017101943.4132fa8d@sinkhole.intrcomm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is it possible to find the intersection of two array values?

a = '{1,2,3}'
b = '{2,3,4}'

a intersect b = '{2,3}'

Assume I need to write a pl/pgsql function to do this.

Josh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2007-10-17 15:25:14 Re: Prepared statement parameters for an 'IN ()' clause
Previous Message Chris Browne 2007-10-17 15:11:34 Re: DROP VIEW lasts forever