From: achill@matrix.gatewaynet.com
To: pgsql-sql@postgresql.org
Subject: contrib/tree issues
Date: Wed, 29 May 2002 19:35:06 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0205291921060.15675-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <3CEE818B.9020702@wildbrain.com>
I have been playing with the tree package, and so far
it seems fast.
But i have some questions:
How can we find "maximum" direct child of a node?
e.g.
The table has as:
dynatree=# SELECT node from achtree ;
node
-------
1
2
1.1
1.1.1
1.2
(5 rows)
dynatree=#
Now we find the children of '1' of level 2:
dynatree=# SELECT node from achtree where node <* '1.*.0';
node
------
1.1
1.2
(2 rows)
dynatree=#
Now if we want to insert another level 2 child of '1',
how can we get the current maximum value of level 2 children of node '1'??
(in this case 2), so that we can insert '1.3' to the table???
Also, i want to ask if somebody has extended postgresql's jdbc
implemantation to include support for bitrees,entrees.
One maybe slow solution for both of the above would be to
be able to cast e.g. entree to text, so that
a) taking the lexicographically maximum bitree value would give the
maximum current child, and
b) java intergration would be trivial through java.lang.String.
Thanx
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: achill@matrix.gatewaynet.com
Subject: Re: contrib/tree issues
In-Reply-To: <Pine.LNX.4.44.0205291921060.15675-100000@matrix.gatewaynet.com>
* 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