From: frederik nietzsche <nietzsche_psql@yahoo.it>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: about Inheritance...
Date: Thu, 18 Jul 2002 12:32:33 +0200 (CEST)
Message-ID: <20020718103233.73392.qmail@web12907.mail.yahoo.com> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: nietzsche_psql@yahoo.it
Subject: Re: about Inheritance...
In-Reply-To: <20020718103233.73392.qmail@web12907.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox