subject:"\[SQL\] using a self referencing table"

Re: [SQL] using a self referencing table

2000-07-18 Thread andrew

[EMAIL PROTECTED] wrote: > i have a table with this structure > > name (varchar)|category id (int4)|parent category id (int4)|leaf node > (bool) > > im trying to make a perl script that should tree the info > > parent cat > subcat > subcat2 > subcat2 >

[SQL] using a self referencing table

2000-07-18 Thread drfrog

i have a table with this structure name (varchar)|category id (int4)|parent category id (int4)|leaf node (bool) im trying to make a perl script that should tree the info parent cat subcat subcat2 subcat2 subcat subcat2 ... but