Re: operator is only a shell - Error - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: operator is only a shell - Error
Date
Msg-id CAKAnmmKe-0KV4vkEjaGvG5KYW+hsJboHt0OmkhZq7FjWhKtyWg@mail.gmail.com
Whole thread Raw
In response to operator is only a shell - Error  (Rajesh S <rajesh.s@fincuro.com>)
Responses Re: operator is only a shell - Error  (Rajesh S <rajesh.s@fincuro.com>)
List pgsql-general
On Fri, Mar 15, 2024 at 6:26 AM Rajesh S <rajesh.s@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

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: select results on pg_class incomplete
Next
From: Greg Sabino Mullane
Date:
Subject: Re: select results on pg_class incomplete