X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E159A9DCA50 for ; Mon, 13 Mar 2006 05:30:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95385-05 for ; Mon, 13 Mar 2006 05:30:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132]) by postgresql.org (Postfix) with ESMTP id 8D9099DCA2F for ; Mon, 13 Mar 2006 05:30:45 -0400 (AST) Received: from [213.162.97.75] (helo=mail.metronet.co.uk) by pih-relay05.plus.net with esmtp (Exim) id 1FIjNw-0003RB-Qh; Mon, 13 Mar 2006 09:30:40 +0000 Received: from mainbox.archonet.com (unknown [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 0F71840DB6E; Mon, 13 Mar 2006 09:03:29 +0000 (GMT) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id DD50515EA4; Mon, 13 Mar 2006 09:03:27 +0000 (GMT) Message-ID: <4415355F.2020001@archonet.com> Date: Mon, 13 Mar 2006 09:03:27 +0000 From: Richard Huxton User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: Robert Paulsen Cc: chester c young , pgsql-sql@postgresql.org Subject: Re: Question re: relational technique References: <20060312172903.6034.qmail@web54305.mail.yahoo.com> <200603121215.46141.robert@paulsenonline.net> In-Reply-To: <200603121215.46141.robert@paulsenonline.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.121 required=5 tests=[AWL=0.121] X-Spam-Score: 0.121 X-Spam-Level: X-Archive-Number: 200603/180 X-Sequence-Number: 24526 Robert Paulsen wrote: > This still requires me to modify the overall database structure but not the > original item table. As my reward :) I get to use any type I choose for each > new attribute. The whole point of the database structure is to accurately reflect the requirements of your data. If you don't want your change your structure to keep track of the real world, why bother to structure it in the first place? Just stick it all in text documents and let htdig free-text search against it. -- Richard Huxton Archonet Ltd