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
***-*--*----*-------*------------*--------------------*---------------
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 |