Re: Arrays instead of join tables - Mailing list pgsql-general

From Lew
Subject Re: Arrays instead of join tables
Date
Msg-id RPadneGQN56NEZPbnZ2dnUVZ_hKdnZ2d@comcast.com
Whole thread Raw
In response to Arrays instead of join tables  (William Garrison <postgres@mobydisk.com>)
List 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

pgsql-general by date:

Previous
From: "Lloyd Mason"
Date:
Subject: Unexplained case insensitive results
Next
From: Lew
Date:
Subject: Re: Deleted Flag/Unique Constraint