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@aranya.com> wrote: 
>         On 18 Jul 2006 09:07:08 -0700, Andrew Hammond
>         <andrew.george.hammond@gmail.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