Re: variant column type

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: variant column type
Дата
Msg-id 4E2EFD37.6060208@hogranch.com
обсуждение исходный текст
Ответ на Re: variant column type  (salah jubeh <s_jubeh@yahoo.com>)
Ответы Re: variant column type
Список pgsql-general
in general, attribute-value sorts of lists are very difficult to use for
relational operations and result in clumsy inefficient queries, as well
as poor data integrity.

whenever possible common attributes shoudl be stored properly as table
fields.   reserve EAV for highly sparse freeform information that could
not have been anticipated at design time.   for your example, all cars
have a speed, and do/don't have an airbag, so these should be normal
fields in a table.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


В списке pgsql-general по дате отправления:

Предыдущее
От: Ben Chobot
Дата:
Сообщение: Re: variant column type
Следующее
От: Filippos
Дата:
Сообщение: heavy load-high cpu itilization