Ühel kenal päeval, T, 2006-07-18 kell 16:44, kirjutas Andrew Hammond: > On 7/18/06, Aaron Bono <[EMAIL PROTECTED]> wrote: > On 18 Jul 2006 09:07:08 -0700, Andrew Hammond > <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
