Re: Arrays instead of join tables

Поиск
Список
Период
Сортировка
От Lew
Тема Re: Arrays instead of join tables
Дата
Msg-id RPadneGQN56NEZPbnZ2dnUVZ_hKdnZ2d@comcast.com
обсуждение исходный текст
Ответ на Arrays instead of join tables  (William Garrison <postgres@mobydisk.com>)
Список 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 по дате отправления:

Предыдущее
От: "Lloyd Mason"
Дата:
Сообщение: Unexplained case insensitive results
Следующее
От: Lew
Дата:
Сообщение: Re: Deleted Flag/Unique Constraint