Dear Martijn,
Wow, didn't know about arrays. Did lots of sql, but, as I think about it,
that was 7 years ago, and we didn't know about arrays then
Are their performance problems with arrays? We will not likely be working
with more than 50,000 - 100,000 records.
Ben
In message <20061103172212.GC551@svana.org> Benjamin Weaver
<benjamin.weaver@classics.oxford.ac.uk>, pgsql-general@postgresql.org writes:
> 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.
--
Benjamin Weaver
Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society,
Oxford
email: benjamin.weaver@classics.ox.ac.uk
phone: (0)1865 288260