Search Postgresql Archives

Array intersection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Array intersection
From: Josh Trutwin <josh@xxxxxxxxxxxxxxxxxxx>
Date: Wed, 17 Oct 2007 10:19:43 -0500

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Array intersection
  - From: David Fetter
- Re: Array intersection
  - From: Josh Trutwin

Prev by Date: Re: What encoding to use for English, French, Spanish
Next by Date: Re: Prepared statement parameters for an 'IN ()' clause
Previous by thread: Prepared statement parameters for an 'IN ()' clause
Next by thread: Re: Array intersection
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux