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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
