Hi all, I'm still in trouble with inheritance. Now I've created some triggers and rules for realize something similiar to an inheritance... I MUST do myself all the check for integrity, it seems the only way. But because psql executes a function in a transaction it was not so bad... In practice, if you insert some datas in a child table, YOU must insert it also in the father table, resulting in having two identical data in the father table. if you don't do that, and you insert only in the child table, you can see the data in the father, but if you SELECT from it, seems it's not there...
I hope it is intelligible. Any of you have ever dealt with such a thing?? I'd like to hear someother's solutions, if any. I've also a question, Is there any sql statement for identify, knowing it's key value, where is (in which child table) a record in the father table?? I have the key of a record in the father, and I want to know in which child table is the real information ok bye and thaks all... danilo ______________________________________________________________________ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità. http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
