primary key over two columns

[Asaf Maruf]

  Dear all on list

How can i specify two columns together as primary key for a table.

Using create table test
(increment int , id int not null primary key, date not null primary key, name char(20) 
);

doesn't work.

Is it possible that one column is text and other is integer?

Help would be appreciated.

Thanks in advance

Asaf Maruf