[Bioperl-l] Re: Comparative genomics

Elia Stupka elia@ebi.ac.uk
Fri, 28 Sep 2001 14:20:22 +0100 (BST)


>  CREATE TABLE Personnel
>  (emp CHAR(10) PRIMARY KEY,
>   boss CHAR(10),       -- this column is unneeded
>   salary DECIMAL(6,2) NOT NULL,
>   lft INTEGER NOT NULL,
>   rgt INTEGER NOT NULL);

Isn't this already an example of the merged structure, i.e. where you
retain the parent-child relationship as well as the lft-rgt schema?

I think I'll go off and write this schema and object asap, sounds really
interesting.

Elia

******************************
* http://www.ebi.ac.uk/~elia *
* tel:    +44 1223 49 44 31  *
* mobile: +44 7971 59 03 69  *
* fax:    +44 1223 49 44 68  *
******************************