.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
: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 '
; (
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
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
= 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