Need help form inherits

This is a multi-part message in MIME format.
--------------000800030706000203030301
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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@dynu.co m');

And all is ok.

Thanks for your help.

Patrice


--------------000800030706000203030301
Content-Type: text/x-vcard; charset=utf-8;
name="oliverp21.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="oliverp21.vcf"

begin:vcard
fn:Patrice OLIVER
n:OLIVER;Patrice
email;internet:oliverp21@free.fr
x-mozilla-html:FALSE
version:2.1
end:vcard


--------------000800030706000203030301
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--------------000800030706000203030301--