From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Mike Sosteric <mikes(at)athabascau(dot)ca> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [GENERAL] arrays |
Date: | 2002-09-30 18:20:09 |
Message-ID: | 200209301120.09427.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Sosteric | 2002-09-30 18:24:13 | Re: [GENERAL] arrays |
Previous Message | Tom Lane | 2002-09-30 18:14:44 | Re: pg_* description |
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Sosteric | 2002-09-30 18:24:13 | Re: [GENERAL] arrays |
Previous Message | Tom Lane | 2002-09-30 18:18:57 | Re: CVS split problems |
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Sosteric | 2002-09-30 18:24:13 | Re: [GENERAL] arrays |
Previous Message | Mike Sosteric | 2002-09-30 18:11:36 | Re: [GENERAL] arrays |