Re: Query-ing arrays

From: Jon Lapham <jlapham(at)gandalf(dot)bioqmed(dot)ufrj(dot)br>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Query-ing arrays
Date: 2000-09-01 18:31:38
Message-ID: 20000901153138.A19914@gandalf.bioqmed.ufrj.br
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Sep 01, 2000 at 09:07:35AM -0700, Stephan Szabo wrote:
>
> I'd suggest checking the array utilities in contrib. I believe
> it has functions/operators for element in set.

Thanks, that looks like exactly what I need. I wonder if someone could
put a reference to this array utility package in the manual, chapter 8, on
arrays.

Maybe something like this:
For more complex work with arrays, see Massimo Dal Zotto's contrib package
'array_iterator'. This loadable module "...defines a new class of
functions which take an array and a scalar value, iterate a scalar
operator over the elements of the array and the value, and compute a
result as the logical OR or AND of the iteration results."

--

-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Centro Nacional de Ressonancia Magnetica Nuclear de Macromoleculas
Universidade Federal do Rio de Janeiro (UFRJ) - Brasil
email: jlapham(at)gandalf(dot)bioqmed(dot)ufrj(dot)br
***-*--*----*-------*------------*--------------------*---------------

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Brian C. Doyle 2000-09-03 11:25:23 Re: Week of the Year?
Previous Message Stephan Szabo 2000-09-01 16:07:35 Re: Query-ing arrays