= num_eq_varchar,
LEFTARG = numeric,
RIGHTARG = 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 respon
type.
But before creating the function and operator it was 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 n
; (
FUNCTION = num_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 o
:varchar) -
to_char(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 '
.dt_minus_dt,
LEFTARG = timestamp without time zone,
RIGHTARG = timestamp 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
