<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>
