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 по дате отправления: