Postgres Pro
Downloads
Home   >   mailing lists

Re: explosion of tiny tables representing multiple fields--Is this necessary? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: explosion of tiny tables representing multiple fields--Is this necessary?
Date
Msg-id 20061103172212.GC551@svana.org
Whole thread Raw
In response to explosion of tiny tables representing multiple fields--Is this necessary?  (Benjamin Weaver <benjamin.weaver@classics.oxford.ac.uk>)
Responses Re: explosion of tiny tables representing multiple
List pgsql-general
Tree view 
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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
Attachment

pgsql-general by date:

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