Re: Query-ing arrays - Mailing list pgsql-sql

From Jon Lapham
Subject Re: Query-ing arrays
Date
Msg-id 20000901153138.A19914@gandalf.bioqmed.ufrj.br
Whole thread Raw
In response to Re: Query-ing arrays  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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 LaphamCentro Nacional de Ressonancia
MagneticaNuclear de MacromoleculasUniversidade Federal do Rio de Janeiro (UFRJ) - Brasilemail:
jlapham@gandalf.bioqmed.ufrj.br 
 
***-*--*----*-------*------------*--------------------*---------------


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Query-ing arrays
Next
From: "Brian C. Doyle"
Date:
Subject: Re: Week of the Year?