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),
lastn
cture.symbole s
on t.typcode = s.typcode;
Is it possible ?
Do i have to return results in an array ?
If yes, how could i do ?
Do you think using plPHP mays help me ?
Regards,
Patrice OLIVER.
---(end of broadcast)---
TIP 7: don't forget to increase
Hello,
In this example, I use 2 tables :
create table types (
typnum integer primary key,
catcode varchar(2),
typlib varchar(35));
create table uv (
uvnum varchar(5) primary key,
typnum integer,
uvlib varchar(50));
alter table uv
add constraint fk_uv_type foreign key (typnum)
references type
To try to solve my precedent problem (PB with stored procedure), I made
this :
Table "structure.categtype"
Column | Type | Modifiers
-+--+---
catcode | varchar(5) | not null
catlib | varchar(35) |
Indexes:
"pk_categtype" primary key, btree (catcode)
Table "st
unsubscribe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
unsubscribe
--
Patrice Oliver
Utilisateur GNU / Linux Enregistré 430054 http://counter.li.org
Jabber ID : [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http
