Re: [SQL] SQL tree duplication

2008-01-24 Thread tv
> Hi, > > I have the following kind of sql structure, in 3 levels: > > --- > create table documents ( > id serial, > name varchar(50), > primary key (id) > ); > > create table lines ( > id serial, > name varchar(50), > document_id integer, > primary key (id), > f

[SQL] SQL tree duplication

2008-01-24 Thread Philippe Lang
Hi, I have the following kind of sql structure, in 3 levels: --- create table documents ( id serial, name varchar(50), primary key (id) ); create table lines ( id serial, name varchar(50), document_id integer, primary key (id), foreign key (document_id) refere