From: Oleg Bartunov <oleg@sai.msu.su>
To: PFC <lists@boutiquenumerique.com>
Cc: pgsql-sql@postgresql.org
Cc: teodor@sigaev.ru
Subject: Re: assorted problems with intarray and other GiST contribs.
Date: Sun, 26 Jun 2005 21:41:51 +0400 (MSD)
Message-ID: <Pine.GSO.4.63.0506262136370.26882@ra.sai.msu.su> (raw)
In-Reply-To: <op.sszkzgnith1vuj@localhost>
References: <a053b85772b71eaf158e0354551e72d2@biglumber.com>
<op.sszkzgnith1vuj@localhost>
On Sun, 26 Jun 2005, PFC wrote:
>
> Hello !
>
> I'm using postgresql 8.0.1-r2 on gentoo linux.
> So, here are the problems :
>
> ************************************
> * int_array_aggregate crashes
I don't remember this function :)
> * ltree
>
> First of all congratulations for this extremely useful datatype and
> assorted indexes, it really rocks and makes SQL tree handling from nightmare
> to fun.
>
> It would be nice to have functions to :
> - know the length of a ltree (ie. number of elements)
int4 nlevel(ltree) - returns level of the node.
> - access it like an array (ie. get element N).
subltree, subpath
> This is to be able to iterate over the elements and fetch each of
> them to get the list of rows which make up a path upto a given object in my
> tree.
>
> Also a function returning the comon prefix between two ltrees would
> be really useful.
ltree lca(ltree,ltree,...) (up to 8 arguments)
ltree lca(ltree[])
Returns Lowest Common Ancestor (lca)
Have you read README.ltree ?
>
>
> Thanks and sorry to come bother you !
> Regards,
> PF Caillaud
>
Regards,
Oleg
_____________________________________________________________
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, lists@boutiquenumerique.com, teodor@sigaev.ru
Subject: Re: assorted problems with intarray and other GiST contribs.
In-Reply-To: <Pine.GSO.4.63.0506262136370.26882@ra.sai.msu.su>
* 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