On Fri, Mar 15, 2024 at 6:26 AM Rajesh S <rajesh(dot)s(at)fincuro(dot)com> wrote:
> I wanted to implement a new "=" (equal) operator with LEFTARG as numeric
> and RIGHTARG as varchar. But after creating the function and operator,
> psql shows the error "operator is only a shell: character varying =
> numeric
>
Your operator has numeric on the left and varchar on the right. But your
query is doing numeric on the RIGHT. Probably want to make a matching one
to cover both cases.
Cheers,
Greg