From: | Patrice OLIVER <oliverp21(at)free(dot)fr> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Need help form inherits |
Date: | 2004-08-01 16:07:34 |
Message-ID: | 410D1546.2060607@free.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello everybody,
I would like to use inherits between 2 tables :
user(login,password)
and
studiant(firstname, lastname, email)
these tables are created like this :
create table user (
login varchar(15) not null primary key,
password varchar(32));
create table studiant (
firstname varchar(35),
lastname varchar(35),
email varchar(255)
) inherits user;
The problem is that a studiant can become a user of the site to consult
its results. Members of user table are actually secretaries, who
administer exams ...
so, if I create un user :
insert into user values ('por',md5('tototo'));
and I want know to say that the user 'por' becomes a studiant. How can I
do this ?
In the other way, to say that a studiant is also a user, I just have to do :
insert into studiant
('kml',md5('tititi'),'Michel','Michelle','michelle21(at)dynu(dot)com');
And all is ok.
Thanks for your help.
Patrice
Attachment | Content-Type | Size |
---|---|---|
oliverp21.vcf | text/x-vcard | 124 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2004-08-02 04:25:41 | Re: How to create an aggregate? |
Previous Message | Tom Lane | 2004-07-31 00:50:39 | Re: How to create an aggregate? |