From: Josh Berkus <josh@agliodbs.com>
To: Mike Sosteric <mikes@athabascau.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: [GENERAL] arrays
Date: Mon, 30 Sep 2002 11:20:09 -0700
Message-ID: <200209301120.09427.josh@agliodbs.com> (raw)
In-Reply-To: <Pine.SUN.3.96.1020930120856.18945B-100000@aupair.cs.athabascau.ca>
References: <Pine.SUN.3.96.1020930120856.18945B-100000@aupair.cs.athabascau.ca>
Mike,
> has an language attribute. if there are, say 67 seperate items, each with
> multiple languages, then the comlexity of the table structure skyrockets
> because you have to allow for multiple titles, multiple names, multiple
> everything.
This looks soluable several ways.
Question #1: If each record has 67 fields, and each field may appear in
several languages, is it possible for some fields to be in more languages
than others? I.e. if "title-en" and "title-de" exist, does it follow that
"content-en" and "content-de" exist as well? Or not?
Question #2: Does your XML schema allow locall defined attributes? That is,
do some records have entire attributes ("fields" ) that other records do not?
Suggestion #1: Joe Celko's "SQL for Smarties, 2nd Ed." is an excellent book
for giving you ideas on how to adapt SQL structures to odd purposes.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, mikes@athabascau.ca
Subject: Re: [GENERAL] arrays
In-Reply-To: <200209301120.09427.josh@agliodbs.com>
* 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