index on int8 in PG 6.4.2

From: Mirek Budzanowski <mirekb(at)tcs(dot)uni(dot)wroc(dot)pl>
To: pgsql-sql(at)hub(dot)org
Subject: index on int8 in PG 6.4.2
Date: 1999-05-24 23:46:29
Message-ID: 199905242346.BAA13369@pogwizd.ii.uni.wroc.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-05-24 23:59:32 Re: [SQL] Re: pgsql-sql-digest V1 #225
Previous Message Bruce Momjian 1999-05-24 21:25:33 Re: [SQL] Re: pgsql-sql-digest V1 #225