0

I am trying to create a operator class for my index in postgres. But when creating extension i am getting a error " invalid function number 4, must be between 1 and 3". I dont know where this error is occured my operator class is

CREATE OPERATOR CLASS bool_ops DEFAULT
    FOR TYPE bool USING lsm3 AS
    OPERATOR 1  <,
    OPERATOR 2  <=,
    OPERATOR 3  =,
    OPERATOR 4  >=,
    OPERATOR 5  >,
    FUNCTION 1  btboolcmp(bool,bool),
    FUNCTION 4  btequalimage(oid);
Adrian Klaver
  • 15,886
  • 2
  • 17
  • 28
paras garg
  • 1
  • Your access method handler (not shown) defines how many support functions there can be. It must have a mismatch with what you are trying to do in the code you do show. – jjanes Dec 12 '20 at 19:02
  • I am providing amstrategies and amsupport both 5 – paras garg Dec 13 '20 at 18:21
  • I can't reproduce that. Where would the '3' in the error message be coming from, if not from the amsupport you provided in the handler? – jjanes Dec 13 '20 at 21:28

0 Answers0