Postgres Pro
Downloads
Home   >   mailing lists

Array intersection - Mailing list pgsql-general

From Josh Trutwin
Subject Array intersection
Date
Msg-id 20071017101943.4132fa8d@sinkhole.intrcomm.net
Whole thread Raw
Responses Re: Array intersection  (Josh Trutwin <josh@trutwins.homeip.net>)
Re: Array intersection  (David Fetter <david@fetter.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: What encoding to use for English, French, Spanish
Next
From: Sam Mason
Date:
Subject: Re: Prepared statement parameters for an 'IN ()' clause