RE: Tree structure
| От | Trewern, Ben |
|---|---|
| Тема | RE: Tree structure |
| Дата | |
| Msg-id | 996802F75C3CD411B424001083FA445B0594B3@CET_PONXX_FP001 обсуждение исходный текст |
| Ответ на | Tree structure ("Trewern, Ben" <Ben.Trewern@mowlem.com>) |
| Список | pgsql-sql |
<p><font size="2">Any details you can supply would be appreciated. I have got a table at the moment as:</font><p><font size="2"> id| group_name | parentid</font><br /><font size="2">-------------------------------</font><br /><font size="2"> 1 | Main |</font><br /><font size="2"> 2 | Group |</font><br /><font size="2"> 3 | User |</font><br /><font size="2"> 4 | Group1 | 1</font><br /><font size="2"> 5 | Group2 | 1</font><br/><font size="2"> 6 | Group2-1 | 5</font><p><font size="2">Just for testing. I can see how it should workbut the client side code is defeating me at the moment. I'm working in delphi with winzeos (cracking components by theway). Anyone done this.</font><p><font size="2">Thanks for any help</font><p><font size="2">Ben Trewern</font><p><fontsize="2">> -----Original Message-----</font><br /><font size="2">> From: kovacsz [<a href="mailto:zoli@pc10.radnoti-szeged.sulinet.hu">mailto:zoli@pc10.radnoti-szeged.sulinet.hu</a>]</font><br/><font size="2">>Sent: 12 September 2000 10:23</font><br /><font size="2">> To: Zeljko Trogrlic</font><br /><font size="2">>Cc: Trewern, Ben; 'pgsql-sql@postgresql.org'</font><br /><font size="2">> Subject: Re: [SQL] Tree structure</font><br/><font size="2">> </font><br /><font size="2">> </font><br /><font size="2">> We are using treestructures (and partially ordered trees) with</font><br /><font size="2">> PostgreSQL. After the beginning successwe got into speed </font><br /><font size="2">> problems. With</font><br /><font size="2">> special plus tables,triggers and functions now we have a </font><br /><font size="2">> reasonably fast</font><br /><font size="2">>database which contains about 5-10 tree structures. If you </font><br /><font size="2">> are interested,</font><br/><font size="2">> I may send you some of these part of our database. But, </font><br /><font size="2">>PostgreSQL "from </font><br /><font size="2">> base" doesn't support tree structures, neither recursions</font><br /><font size="2">> (like in SQL3), </font><br /><font size="2">> as far as I know (see TODO list).</font><br/><font size="2">> </font>
В списке pgsql-sql по дате отправления: