Re: Why it is not possible to create custom AM which behaves similar to btree? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why it is not possible to create custom AM which behaves similar to btree?
Date
Msg-id 88176.1595463069@sss.pgh.pa.us
Whole thread Raw
In response to Why it is not possible to create custom AM which behaves similar to btree?  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Why it is not possible to create custom AM which behaves similar to btree?  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
List pgsql-hackers
Konstantin Knizhnik <k.knizhnik@postgrespro.ru> writes:
> But then I get error for btfloat48cmp and btfloat84cmp functions:
> ERROR:  associated data types must be specified for index support function

You need to specify the amproclefttype and amprocrighttype types you
want the function to be registered under.  The core code knows that
for btree, those are the same as the actual parameter types of the
function; but there's no reason to make such an assumption for other AMs.
So you have to write it out; perhaps

 ...
 FUNCTION 1(float4,float8) btfloat48cmp(float4,float8),
 ...

            regards, tom lane





pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Infinities in type numeric
Next
From: Soumyadeep Chakraborty
Date:
Subject: Re: [Patch] ALTER SYSTEM READ ONLY