Re: [SQL] composite primary keys.

> Dear All,
>
> Does postgreSQL 6.3.2 support composite primary keys? If so, how do you
> implement these?

Let me know if I understand...

Do you want to build primary keys with more than one element ???

Try with:

create table t1 ( field1 int, field2 int, field3 int,
primary key (field1,field2));

The primary key can contain as many elements as you want. But if what you
want is to activate referential integrity constraints, read about SPI in
your documentation.

Buena Suerte Amigo !!

_______________________________________
David Martinez Cuevas
Direccion General de Estadistica, UNAM - Mexico
Tel. 622-60-80
E-mail david(at)estadistica(dot)unam(dot)mx
----------------------------------------