Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBVMSnL06634
	for <pgsql-sql@postgresql.org>; Sun, 31 Dec 2000 17:28:49 -0500 (EST)
	(envelope-from oleg@sai.msu.su)
Received: from ra (ra [158.250.29.2])
	by ra.sai.msu.su (8.9.3/8.9.3) with SMTP id BAA13775;
	Mon, 1 Jan 2001 01:28:21 +0300 (GMT)
Date: Mon, 1 Jan 2001 01:28:20 +0300 (GMT)
From: Oleg Bartunov <oleg@sai.msu.su>
X-Sender: megera@ra
To: Albert REINER <areiner@tph.tuwien.ac.at>
cc: PostgreSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: Arrays
In-Reply-To: <20001231222933.A227@frithjof>
Message-ID: <Pine.GSO.3.96.SK.1010101012201.13201O-100000@ra>
Organization: Sternberg Astronomical Institute (Moscow University)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200012/321
X-Sequence-Number: 661

Wait some time. We have something you need - we implement RD-tree
using GiST interface. Unfortunately, GiST was very poorly tested
and supported, so we have to understand, fix and rewrite some part of code. 
There are still some problems but we hope to get working code in January.

	Oleg
On Sun, 31 Dec 2000, Albert REINER wrote:

> Date: Sun, 31 Dec 2000 22:29:33 +0100
> From: Albert REINER <areiner@tph.tuwien.ac.at>
> To: PostgreSQL-SQL <pgsql-sql@postgresql.org>
> Subject: [SQL] Arrays
> 
> Saluton,
> 
> I somehow get the impressions that support for arrays is not a high
> priority with PostgreSQL, even though I think it would be very
> handy. On the other hand, the system itself uses arrays e.g. for user
> groups, so I guess there should be readily available
> functions/operators for dealing with that, but I cannot seem to be
> able to find them.
> 
> Is there a simple way of checking whether e.g. a given int4 is in a
> given int4-array?
> 
> Is there a way to "thread" a command over an array? By this I mean:
> Given an array {1, 2, 3} and a table t like
> 
>    id   |  name
> --------|--------
>    1    |  joe
>    2    |  fred
>    3    |  mark
> 
> , a call to select thread('||', t, {1,2,3}) should produce
> 'joefredmark'.
> 
> Thanks in advance,
> 
> Albert.
> 
> 
> -- 
> 
> --------------------------------------------------------------------------
> Albert Reiner                                   <areiner@tph.tuwien.ac.at>
> Deutsch       *       English       *       Esperanto       *       Latine
> --------------------------------------------------------------------------
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83