[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Arrays instead of join tables
From:       Lew <lew () nospam ! lewscanon ! com>
Date:       2007-03-31 16:28:00
Message-ID: RPadneGQN56NEZPbnZ2dnUVZ_hKdnZ2d () comcast ! com
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
[prev in list] [next in list] [prev in thread] [next in thread]