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

From Konstantin Knizhnik
Subject Re: Why it is not possible to create custom AM which behaves similar to btree?
Date
Msg-id 3a66de75-cba0-ccdb-db11-41f4779a813c@postgrespro.ru
Whole thread Raw
In response to Re: Why it is not possible to create custom AM which behaves similar to btree?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On 23.07.2020 03:11, Tom Lane wrote:
> 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),
>   ...

Thank you very much.
It works!




pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Compatible defaults for LEAD/LAG
Next
From: Bharath Rupireddy
Date:
Subject: Re: Parallel copy