Re: [SQL] using constraint based paritioning to fix EAV

Ühel kenal päeval, T, 2006-07-18 kell 16:44, kirjutas Andrew Hammond:
> On 7/18/06, Aaron Bono <postgresql(at)aranya(dot)com> wrote:
> On 18 Jul 2006 09:07:08 -0700, Andrew Hammond
> <andrew(dot)george(dot)hammond(at)gmail(dot)com> wrote:
>
> I have a client with the following EAV inspired
> schema.
>
> CREATE TABLE many_tables (
> table_id text primary key, -- defines which
> virtual table is
> encoded
> attribute1 text,
> attribute2 text,
> attribute3 text,
> attribute4 text,
> ...
> );

Maybe you can approach the problem from another end, and make the
many_tables table the virtual one and all the others into real tables ?

--
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me: callto:hkrosing
Get Skype for free: http://www.skype.com