Received: from clio.trends.ca (root@clio.trends.ca [209.47.148.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e8CBvVJ05654 for ; Tue, 12 Sep 2000 07:57:31 -0400 (EDT) Received: from as104.tel.hr (as104.tel.hr [205.219.255.36]) by clio.trends.ca (8.10.2/8.10.2) with ESMTP id e8CB8gZ17191 for ; Tue, 12 Sep 2000 07:08:42 -0400 (EDT) Received: from proxyplus.universe (ao3-m204.tel.hr [195.29.34.204]) by as104.tel.hr (0.0.0/0.0.0) with ESMTP id NAA485686; Tue, 12 Sep 2000 13:06:11 +0200 (MEST) Received: from 192.168.0.1 by Proxy+; Tue, 12 Sep 2000 11:04:20 GMT Message-Id: <4.1.20000912124859.018dbc88@192.168.0.7> X-Sender: zeljko@192.168.0.7 X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Tue, 12 Sep 2000 12:51:59 +0200 To: kovacsz From: Zeljko Trogrlic Subject: Re: Tree structure Cc: pgsql-sql@postgresql.org In-Reply-To: References: <4.1.20000911182824.018d5078@192.168.0.7> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200009/76 Thanks for your offer, I'll be very interested to see how you did that. I also found very interesting solution at http://www.dbmsmag.com/9603d06.html http://www.dbmsmag.com/9604d06.html http://www.dbmsmag.com/9605d06.html At 11:22 12.9.2000 , kovacsz wrote: >We are using tree structures (and partially ordered trees) with >PostgreSQL. After the beginning success we got into speed problems. With >special plus tables, triggers and functions now we have a reasonably fast >database which contains about 5-10 tree structures. If you are interested, >I may send you some of these part of our database. But, PostgreSQL "from >base" doesn't support tree structures, neither recursions (like in SQL3), >as far as I know (see TODO list).