Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA06315 for ; Fri, 15 May 1998 16:35:17 -0400 (EDT) Received: by bjke.com; id QAA05721; Fri, 15 May 1998 16:34:19 -0400 (EDT) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (3.2) id xmaa04535; Fri, 15 May 98 16:32:40 -0400 Received: by dal_cps.cpsgroup.com with Internet Mail Service (5.0.1458.49) id ; Fri, 15 May 1998 15:34:19 -0500 Message-ID: From: "Jackson, DeJuan" To: Romualdo Alves , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Indexing Timestamp Data Date: Fri, 15 May 1998 15:34:18 -0500 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain Just as a suggestion you might want to use DATETIME instead of TIMESTAMP. > How to index a timestamp data in a Postgres table? > > For example, I tried: CREATE UNIQUE INDEX idx ON table_01 > (xtime); > The resulting message was: "CAN'T FIND A DEFAULT OPERATOR CLASS FOR > TYPE > 1296". > > The table 'table_01' was created with the following command: > CREATE TABLE table_01 ( > xtime TIMESTAMP, > code CHAR(5), > qty INTEGER); > > The key of this table must be the 'xtime' field which is of > TIMESTAMP data > type. How to do it? > > > Romualdo. > > > ------------------------------------------------------------ > My ICQ# 10480879 > My Home Page: http://wwp.mirabilis.com/10480879 > My E-mail Express: 10480879@pager.mirabilis.com > INPE Telephone Number: (084) 231-4733 Ext. 214 > > "For we are labourers together with God" (1 Corinthians 3:9) > "De Deus somos cooperadores" (1 Corintios 3:9) > ------------------------------------------------------------