Hello All,
I have just searched the pgsql-sql mail archive for the tree keyword.
I have found several interesting articles in the field of graphs:
http://www.postgresql.org/mhonarc/pgsql-sql/1999-01/msg00065.htmlhttp://www.postgresql.org/mhonarc/pgsql-sql/1999-01/msg00107.htmlhttp://www.postgresql.org/mhonarc/pgsql-sql/1999-01/msg00081.html
>From this articles is more or less clear what one can do with one big
graph.
My situation is a little bit differs. I want to write down molecules
like graphs (it is realy common because of the connectivity matrix) to
have the opportunity to search a substructure (subgraph).
The problem is that I have more than one molecule. Is it a good or bad
idea to create a type like this
id
atom_type
charge
connected_to_id(10 times)
bond_type(10 times)
and create an other type as an array of the first type? After this I can
write down a molecule in one row of my table.
Has anyone some idea or experience in this field?
Laszlo Molnar
Gedeon Richter Ltd.
Hungary