Re: operator is only a shell - Error

2024-03-19 Thread Rajesh S
TARG = varchar, -- COMMUTATOR = =, -- NEGATOR = <>,     RESTRICT = eqsel,     JOIN = eqjoinsel,     HASHES, MERGES ); Thanks, Rajesh S On 18-03-2024 21:20, Adrian Klaver wrote: On 3/18/24 00:05, Rajesh S wrote: Thank you for your response.  Actually, I was trying to address the

Re: operator is only a shell - Error

2024-03-18 Thread Rajesh S
working fine.  Tried dropping the same, even though the same error.  How to proceed now? Thanks, Rajesh S On 15-03-2024 19:10, Greg Sabino Mullane wrote: On Fri, Mar 15, 2024 at 6:26 AM Rajesh S wrote: I wanted to implement a new "=" (equal) operator with LEFTARG as nu

operator is only a shell - Error

2024-03-15 Thread Rajesh S
um_ne_varchar,     LEFTARG = numeric,     RIGHTARG = varchar,     COMMUTATOR = <>,     NEGATOR = =,     RESTRICT = neqsel,     JOIN = neqjoinsel ); Thanks, Rajesh S On 05-07-2022 13:52, Rajesh S wrote: Hi, We are migrating our database from Oracle to Postgresql.  In oracle we have used

Re: - operator overloading not giving expected result

2022-07-11 Thread Rajesh S
(dt2::date,'J'::varchar))::integer $$ LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE COST 1; CREATE OPERATOR public.- (   PROCEDURE = dt_minus_dt,   LEFTARG = DATE,   RIGHTARG = DATE ); Thanks, Rajesh S On 08-07-2022 08:05 pm, Ravi Krishna wrote: LANGUAGE 'edbspl' This is the root cause of

- operator overloading not giving expected result

2022-07-08 Thread Rajesh S
p without time zone ); SELECT ('1999-12-30'::DATE) === ('1999-12-11'::DATE) I really appreciate anyone's help in resolving this case.  Thanks in advance. Rajesh S