Answer the question
In order to leave comments, you need to log in
How does comparison of different types work in PostgreSQL?
I didn't find it in the documentation, I can only guess.
Here both values are converted to timestamp type and compared?
select '2021-01-01'::date = '2021-01-01 12:00'::timestamp;
select 5::numeric = 5::integer;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question