X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AEEA9D1B55A for ; Wed, 22 Oct 2003 21:44:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 98247-09 for ; Wed, 22 Oct 2003 18:43:59 -0300 (ADT) Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by svr1.postgresql.org (Postfix) with ESMTP id 2E224D1B557 for ; Wed, 22 Oct 2003 18:43:53 -0300 (ADT) Received: from dunslane.net (x.ncshp.org [199.90.235.43]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id h9MLbYX19763 for ; Wed, 22 Oct 2003 16:37:35 -0500 Message-ID: <3F96FA03.6040009@dunslane.net> Date: Wed, 22 Oct 2003 17:43:31 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030703 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-hackers@postgresql.org Subject: Re: is GiST still alive? References: <200310220438.h9M4cY232554@hosting.commandprompt.com> <200310221219.43179.josh@agliodbs.com> <60ptgpf175.fsf@dev6.int.libertyrms.info> In-Reply-To: <60ptgpf175.fsf@dev6.int.libertyrms.info> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/1055 X-Sequence-Number: 45737 Christopher Browne wrote: >But I think back to the XML generator I wrote for GnuCash; it has the >notion of building up a hierarchy of entities and attributes, each of >which is visible as an identifyable object of some sort. Mapping that >onto a set of PostgreSQL relations wouldn't work terribly well. > > *nod* I have tried this several times - it just doesn't work well, because the maps are too different. You could do something like this: . a table for each element type, fields being the attributes, plus the node id. . a table to tie everything together (parent_id, child_id, child_order, child_type). In theory you could even generate the DB schema from an XML schema and evaluate it with XPath-like expressions. But why put yourself to such bother? I have never found a good reason to do this sort of thing. cheers andrew