Re: Recursive queries
От | PFC |
---|---|
Тема | Re: Recursive queries |
Дата | |
Msg-id | opsk8h98evth1vuj@musicbox обсуждение исходный текст |
Ответ на | Re: Recursive queries (tmp <skrald@amossen.dk>) |
Список | pgsql-general |
Check out ltree http://www.sai.msu.su/~megera/postgres/gist/ltree/ On Tue, 25 Jan 2005 22:03:58 +0100, tmp <skrald@amossen.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 >
В списке pgsql-general по дате отправления: