Ühel kenal päeval, K, 2006-07-19 kell 00:20, kirjutas Hannu Krosing: > Ü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 ?
Oops, I see you kind of are :) Maybe you can solve some of the problems doing a VIEW over pl/SQL function ? And/or maybe using triggers instead of rules. -- ---------------- 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 4: Have you searched our list archives? http://archives.postgresql.org
