pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.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




Message-ID: <37DF7B1F.65C92071@richter.hu>
Permalink:  ../37DF7B1F.65C92071@richter.hu/
Also on:    postgresql.org/message-id/37DF7B1F.65C92071@richter.hu

 · 

reply

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