Check out ltree
http://www.sai.msu.su/~megera/postgres/gist/ltree/
On Tue, 25 Jan 2005 22:03:58 +0100, tmp <skrald@xxxxxxxxxx> wrote:
I don't think anybody has written the syntactic sugar, but someone did write a function that provides equivalent output.
I think it is important that the funcionality lies in the database engine itself: In that way it can more efficiently make use of the optimizer.
Also, I think this "recursive" feature is *the* most important upcoming improvements: Currently there are simply no efficient way of fetching linked structures, which however is quite common in many areas.
Regards
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
