Re: Array comparison - subset - Mailing list pgsql-general

From Christopher Murtagh
Subject Re: Array comparison - subset
Date
Msg-id 92fbb7920609041142r47b145fep6199679f63873f8f@mail.gmail.com
Whole thread Raw
In response to Re: Array comparison - subset  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On 9/3/06, Michael Fuhr <mike@fuhr.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

pgsql-general by date:

Previous
From: "Frank Church"
Date:
Subject: Re: Syntax for converting double to a timestamp
Next
From: gustavo halperin
Date:
Subject: Porting from ORACLE to PostgSQL