Re: [SQL] arrays - Mailing list pgsql-sql

From neko@kredit.sth.szif.hu
Subject Re: [SQL] arrays
Date
Msg-id Pine.LNX.4.10.9912041551160.24572-100000@kredit.sth.szif.hu
Whole thread Raw
In response to Re: [SQL] arrays  ("John M. Flinchbaugh" <glynis@butterfly.hjsoft.com>)
List pgsql-sql
On Sat, 4 Dec 1999, John M. Flinchbaugh wrote:
> > Trying to fully normalise attributes like these leads to nonsensical and 
> > unusable database designs.

> ``slots''.  say you give each publication an array to hold 3
> authors.  what happens when that 4th author comes along, then a
> fifth?  you always have a +1 problem.  your database design will stand the
> test of time better if you keep a good design.
> 
> one may say, ``just put 100 slots for authors''.  then you are just
Hmm... But you can create an array field with variable size. So, it's not
waste the space, and have only one limit: 8k record size.
So, feel free to use arrays.
best regards:

--nek;(



pgsql-sql by date:

Previous
From: "John M. Flinchbaugh"
Date:
Subject: Re: [SQL] arrays
Next
From: Tom Lane
Date:
Subject: Re: [SQL] arrays