using a self referencing table

From: drfrog(at)smartt(dot)com
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: using a self referencing table
Date: 2000-07-18 16:05:49
Message-ID: 3974805D.6C33895E@smartt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 im having troubles wrapping my head around this

im using the Pg modules to access postgres

if anyone has any suggestions please lemme know thanks!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2000-07-18 19:35:42 Re: Median
Previous Message Tubagus Nizomi 2000-07-18 07:00:55 describe table in 7.0.2