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

Reply via email to