Re: Recursive queries

Check out ltree

http://www.sai.msu.su/~megera/postgres/gist/ltree/

On Tue, 25 Jan 2005 22:03:58 +0100, tmp <skrald(at)amossen(dot)dk> 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
>