From: Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
To: pgsql-sql@postgresql.org
Subject: Re: Storing properties in a logical way.
Date: Sun, 05 Sep 2004 19:51:44 +0200
Message-ID: <opsdu7wi2ecq72hf@musicbox> (raw)
In-Reply-To: <413BDCB7.10009@nm.ru>
References: <413BDCB7.10009@nm.ru>
> But after looking closely at the list of a possible properties, i found
> out that some of them depend on others. For example, if item is a
> PDF document, it can have an index. But a document can also have an
> index with links. Logically, a properties like 'index with links'
> don't belong to the verification table - they look like a kind of
> a composite field - 'index with links' is not a stand-alone property,
> but it also implies that an item also has an 'index' property.
> On the other hand, it is impossible to decouple 'index' from
> 'with links', because the second part won't have any meaning without
> the first part.
You mean your properties would be better organized as a tree ?
Or is it even more complicated than that ?
If it's a tree, look at the ways of storing a tree in a table.
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lists@boutiquenumerique.com
Subject: Re: Storing properties in a logical way.
In-Reply-To: <opsdu7wi2ecq72hf@musicbox>
* 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