Re: Array comparison - subset

From: "Christopher Murtagh" <christopher(dot)murtagh(at)gmail(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Array comparison - subset
Date: 2006-09-04 18:42:45
Message-ID: 92fbb7920609041142r47b145fep6199679f63873f8f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/3/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> On Fri, Sep 01, 2006 at 11:55:32AM -0400, Christopher Murtagh wrote:
> > I've got a function that returns and array $foo, and an array $bar.
> > Is there an elegant way to test if $bar is a subset of $foo? I've been
> > looking through the docs and haven't found anything. Am I missing
> > something obvious, or am I out of luck?
>
> In the specific case of integer arrays you could use contrib/intarray.

Cool. This is exactly what I needed. Thanks a bunch!

Cheers,

Chris

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michelle Konzack 2006-09-04 19:36:21 Re: Tsearch2 & Hebrew
Previous Message Frank Church 2006-09-04 18:10:57 Re: Syntax for converting double to a timestamp