Re: assorted problems with intarray and other GiST contribs. - Mailing list pgsql-sql

From Oleg Bartunov
Subject Re: assorted problems with intarray and other GiST contribs.
Date
Msg-id Pine.GSO.4.63.0506262136370.26882@ra.sai.msu.su
Whole thread Raw
In response to assorted problems with intarray and other GiST contribs.  (PFC <lists@boutiquenumerique.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: PFC
Date:
Subject: assorted problems with intarray and other GiST contribs.
Next
From: PFC
Date:
Subject: Re: assorted problems with intarray and other GiST contribs.