Skip site navigation (1) Skip section navigation (2)

Re: Arrays

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Albert REINER <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
Cc: PostgreSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Arrays
Date: 2000-12-31 22:28:20
Message-ID: Pine.GSO.3.96.SK.1010101012201.13201O-100000@ra (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)tph(dot)tuwien(dot)ac(dot)at>
> To: PostgreSQL-SQL <pgsql-sql(at)postgresql(dot)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(at)tph(dot)tuwien(dot)ac(dot)at>
> Deutsch       *       English       *       Esperanto       *       Latine
> --------------------------------------------------------------------------
> 

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


In response to

  • Arrays at 2000-12-31 21:29:33 from Albert REINER

pgsql-sql by date

Next:From: Michael DavisDate: 2001-01-01 10:19:37
Subject: Updating two table via a Rule?
Previous:From: Albert REINERDate: 2000-12-31 21:29:33
Subject: Arrays

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group