On Fri, Mar 15, 2024 at 6:26 AM Rajesh S <rajesh.s@xxxxxxxxxxx> 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
