Re: explosion of tiny tables representing multiple fields--Is this necessary?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Benjamin Weaver <benjamin(dot)weaver(at)classics(dot)oxford(dot)ac(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: explosion of tiny tables representing multiple fields--Is this necessary?
Date: 2006-11-03 17:22:12
Message-ID: 20061103172212.GC551@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 02, 2006 at 04:36:49PM +0000, Benjamin Weaver wrote:
> Dear PostGreSQL experts,
>
>
> I am working with text objects. A text object will have lots of fields that
> are potentially multiple. There may be more than one author, more than one
> modern editor, more than one edition number, etc.

Have you considered using arrays?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-03 17:23:41 Re: I can not add up columns when using a left outer join. Any ideas as to why?
Previous Message Richard Broersma Jr 2006-11-03 17:16:43 Re: fetching unique pins in a high-transaction environment...