From: Oleg Bartunov <oleg@sai.msu.su>
To: Albert REINER <areiner@tph.tuwien.ac.at>
Cc: PostgreSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: Arrays
Date: Mon, 1 Jan 2001 01:28:20 +0300 (GMT)
Message-ID: <Pine.GSO.3.96.SK.1010101012201.13201O-100000@ra> (raw)
In-Reply-To: <20001231222933.A227@frithjof>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oleg@sai.msu.su, areiner@tph.tuwien.ac.at
Subject: Re: Arrays
In-Reply-To: <Pine.GSO.3.96.SK.1010101012201.13201O-100000@ra>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox