[SQL] unsubscribe

2007-02-09 Thread Patrice Oliver
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

[SQL] unsubscribe

2006-07-08 Thread Patrice OLIVER
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

[SQL] Pb with insert statement

2004-08-26 Thread Patrice OLIVER
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

[SQL] Problem with stored procedure

2004-08-26 Thread Patrice OLIVER
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

[SQL] stored procedures and type of returned result.

2004-08-24 Thread Patrice OLIVER
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

[SQL] Need help form inherits

2004-08-01 Thread Patrice OLIVER
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