Received: from www.xshare.com (root@www.xshare.de [194.25.119.6]) by hub.org (8.9.3/8.9.3) with SMTP id IAA04256 for ; Mon, 8 Nov 1999 08:31:55 -0500 (EST) (envelope-from plexus@snafu.de) Received: from snafu.de(really [194.25.119.119]) by www.xshare.com via sendmail with smtp id for ; Mon, 8 Nov 1999 15:41:15 +0100 (MET) (Smail-3.2 1996-Jul-4 #1 built 1997-Jun-2) Message-Id: Date: Mon, 8 Nov 1999 14:27:47 +0100 From: Oliver Fischer Reply-To: Oliver Fischer To: pgsql-sql@postgreSQL.org Subject: Creating a index with a timestamp? X-Mailer: Fischer Oliver's registered AK-Mail 3.0b [ger] Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Morning, i have tried to create a table like this.. CREATE TABLE USERS ( NAME TEXT NOT NULL, LOGIN CHAR(18) NOT NULL, PASSWD CHAR(18) NOT NULL, CDATE TIMESTAMP ) Ok, this works. After this i have tried to create a index for the primary key.. CREATE UNIQUE INDEX USERS_PK ON USERS ( LOGIN, CDATE ) But i got an error for the CDATE part of the index. My question is: How could I create a index that contains a timestamp. I need it in several tables for the primary key. MfG Oliver Fischer #--{ plexus@snafu.de }---------------------------- Oliver Fischer, Gleimstrasse 59, 10437 Berlin, Germany