Hello Michael!
Below is a simple example using the data from your original message
Thanks for the example, that realy helps me!
Lg,
AXEL.
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Mon, Feb 20, 2006 at 11:15:43AM +0100, Axel Straschil wrote:
> I have a table with a ltree and acaption "CREATE TABLE (tree LTREE,
> caption TEXT)", I can't store the data of caption in the ltree, becouse of
> the limitation of the ltree labels. I use the ltree to give the captions
> a direco
On Fri, Feb 17, 2006 at 02:28:13PM +, Axel Straschil wrote:
> Im working with the ltree [1] datatype and have labels that can not used
> directly in ltree and a want to get a tree like strukture ordered by the
> labels.
Are you saying that you can't convert labels into ltree values like
'c.a'
Hello!
Im working with the ltree [1] datatype and have labels that can not used
directly in ltree and a want to get a tree like strukture ordered by the
labels.
IE, I've got a table
CREATE TABLE t
(
treeLTREE,
label TEXT
);
and data like
treelabel
---
