Received: from richter.hu ([194.143.226.4]) by hub.org (8.9.3/8.9.3) with SMTP id GAA55264 for ; Wed, 15 Sep 1999 06:54:35 -0400 (EDT) (envelope-from molnar.laszlo@richter.hu) Received: from richter.hu by richter.hu;Wed, 15 Sep 1999 10:55:35 GMT Message-ID: <37DF7B1F.65C92071@richter.hu> Date: Wed, 15 Sep 1999 12:55:27 +0200 From: =?iso-8859-1?Q?Moln=E1r=20L=E1szl=F3?= X-Mailer: Mozilla 4.5 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: trees in postgres Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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