Received: from pogwizd.ii.uni.wroc.pl (pogwizd.ii.uni.wroc.pl [156.17.4.17]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA99973 for ; Mon, 24 May 1999 19:46:39 -0400 (EDT) (envelope-from mirekb@tcs.uni.wroc.pl) Received: from arwena (arwena [156.17.4.16]) by pogwizd.ii.uni.wroc.pl (8.9.1/8.9.1) with SMTP id BAA13369 for ; Tue, 25 May 1999 01:46:28 +0200 (MET DST) Message-Id: <199905242346.BAA13369@pogwizd.ii.uni.wroc.pl> Date: Tue, 25 May 1999 01:46:29 +0200 (MET DST) From: Mirek Budzanowski Reply-To: Mirek Budzanowski Subject: index on int8 in PG 6.4.2 To: pgsql-sql@hub.org MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii Content-MD5: 8riwxTwUj0knVJWf42LSZw== X-Mailer: dtmail 1.2.1 CDE Version 1.2.1 SunOS 5.6 sun4u sparc Hello, I got a table createtd with command: create table test (t int8); When I try: create index i_test on test(t); I get error: ERROR: Can't find a default operator class for type 20. How can I define a default operator for int8??? When I am doing select * from test where t > 4, etc. it works. Anyone have any idea how to define a index ont int8 field? Mirek -- Mirek Budzanowski; P.O. box 1739; 51-161 Wroclaw 8; Poland Tel. +48 602 306674 http://www.tcs.uni.wroc.pl/~mirekb