Message-ID: <410D1546.2060607@free.fr>
Date: Sun, 01 Aug 2004 18:07:34 +0200
From: Patrice OLIVER <oliverp21@free.fr>
User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Need help form inherits
Content-Type: multipart/mixed; boundary="------------000800030706000203030301"

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.com');

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--