Re: variant column type

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: variant column type
Date: 2011-07-26 17:45:27
Message-ID: 4E2EFD37.6060208@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Filippos 2011-07-26 17:47:19 heavy load-high cpu itilization
Previous Message Ben Chobot 2011-07-26 17:37:39 Re: variant column type