Skip site navigation (1) Skip section navigation (2)

default operator (int8le?)

From: Peter Schaefer <schaefer(at)cys(dot)de>
To: "pgsql-bugs(at)postgreSQL(dot)org" <pgsql-bugs(at)postgreSQL(dot)org>
Subject: default operator (int8le?)
Date: 1999-10-14 10:52:29
Message-ID: 3805B5ED.9E04A4CC@cys.de (view raw or flat)
Thread:
Lists: pgsql-bugs
I have a field key that is int8;

create table arg ( key int8 );
	
create index ix_argkey on arg using hash (key) ;
/*ERROR:  Can't find a default operator class for type 20.*/

drop table arg;   

I'm guessing that this is related to the dashed out entries for oprrest and oprjoin.

select oprname, oprcode, oprrest, oprjoin from pg_operator where oprname like '%<%';

oprname|oprcode        |oprrest |oprjoin
-------+---------------+--------+------------
<>     |int48ne        |neqsel  |neqjoinsel
<      |int48lt        |intltsel|intltjoinsel
<=     |int48le        |-       |-
<      |boollt         |intltsel|intltjoinsel
<>     |boolne         |neqsel  |neqjoinsel
<      |int2lt         |intltsel|intltjoinsel
<      |int4lt         |intltsel|intltjoinsel
<>     |int8ne         |neqsel  |neqjoinsel
<      |int8lt         |intltsel|intltjoinsel
<=     |int8le         |-       |-
<>     |int84ne        |neqsel  |neqjoinsel
<      |int84lt        |intltsel|intltjoinsel
<=     |int84le        |-       |-
<<     |poly_left      |intltsel|intltjoinsel

If there is a trick fix, tell me the details, otherwise I'm happy with just reporting the problem.

-- 
Peter Schäfer - mailto:schaefer(at)cys(dot)de, schaefer(at)dfu(dot)de
Motto of the 3D Designer: "I am a meshed potato, I can do the twist".

pgsql-bugs by date

Next:From: Bill ChatfieldDate: 1999-10-17 05:24:33
Subject: JDBC 6.5.1-2 Bug?
Previous:From: CobDate: 1999-10-14 08:40:09
Subject: lobj bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group