Re: Arrays instead of join tables

From: Lew <lew(at)nospam(dot)lewscanon(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Arrays instead of join tables
Date: 2007-03-31 16:28:00
Message-ID: RPadneGQN56NEZPbnZ2dnUVZ_hKdnZ2d@comcast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

William Garrison wrote:
> I've never worked with a database with arrays, so I'm curious what the
> advantages and disadvantages of using it are. For example:

I am prejudiced against arrays because they violate the relational model. I do
not see an advantage over a related table.

Arrays seem to me to re-invent the network database model, which lost out to
the relational model decades ago.

-- Lew

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-03-31 16:28:28 Re: Anyone know where I can get an 8.2.3 binary for ubuntu?
Previous Message Jonathan Barbero 2007-03-31 15:26:16 Instalation problem