From: | Molnár László <molnar(dot)laszlo(at)richter(dot)hu> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | trees in postgres |
Date: | 1999-09-15 10:55:27 |
Message-ID: | 37DF7B1F.65C92071@richter.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.html
http://www.postgresql.org/mhonarc/pgsql-sql/1999-01/msg00107.html
http://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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-09-15 13:46:35 | Re: [HACKERS] BUG with UNIQUE clause |
Previous Message | Pavel Mamin | 1999-09-15 10:11:50 |