Re: [GENERAL] Ltree - how to sort nodes on parent node

And while selected it from table, just cast it to int. I'll check this and his performance after I return from work. I am not interested about recursive queries, i think this kill ltree idea. -- Regards, cojack. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ltree - how to sort nodes on parent node

http://pastebin.com/R4z01LC5 -- never expired link Again, you can see now grouped data in his nodes, this is the outputed data I wanted. If you know better way to make this WITHOUT recursive queries, give me a hint. -- Regards, cojack. -- Sent via pgsql-general mailing list (pgsql-general@post

[GENERAL] Ltree - how to sort nodes on parent node

s, or improve the ltree manual with more example. -- Regards, cojack. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general