From: Molnár László <molnar.laszlo@richter.hu>
To: pgsql-sql@postgresql.org
Subject: trees in postgres
Date: Wed, 15 Sep 1999 12:55:27 +0200
Message-ID: <37DF7B1F.65C92071@richter.hu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: molnar.laszlo@richter.hu
Subject: Re: trees in postgres
In-Reply-To: <37DF7B1F.65C92071@richter.hu>
References: <37DF7B1F.65C92071@richter.hu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox