subject:"\[SQL\] help on creating table"

Re: [SQL] help on creating table

2000-10-25 Thread Albert REINER

Saluton, this is easy: On Fri, Oct 20, 2000 at 06:48:54PM +0800, pgsql-sql wrote: ... > NODE1 >+ --- NODE1_1 >+ --- NODE1_2 >|+ --- NODE1_2_1 >+ --- NODE1_3 create table n (id int4, parent int4, data text); insert into n (id, data) values (1, 'node 1'); insert into n (i

[SQL] help on creating table

2000-10-23 Thread pgsql-sql

Hi All, I'm planning to have data in a tree structure when fetched. e.g. NODE1 + --- NODE1_1 + --- NODE1_2 |+ --- NODE1_2_1 + --- NODE1_3 Is this possible? How? I would really appreciate any help. Sherwin