Re: variant column type - Mailing list pgsql-general

From John R Pierce
Subject Re: variant column type
Date
Msg-id 4E2EFD37.6060208@hogranch.com
Whole thread Raw
In response to Re: variant column type  (salah jubeh <s_jubeh@yahoo.com>)
Responses Re: variant column type
List 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 by date:

Previous
From: Ben Chobot
Date:
Subject: Re: variant column type
Next
From: Filippos
Date:
Subject: heavy load-high cpu itilization