Re: Strange behavior between timestamp and date comparison

2022-07-24 Thread Adrian Klaver
On 7/23/22 03:04, Ludwig Isaac Lim wrote: Hello: Below is a sample case that exhibits a behavior that I can't explain: -- create the table create table ts (t timestamp without time zone); -- populate insert into ts(t) values ('2022-07-16 00:22:06.974000'); insert into ts(t) values ('2022-07-16

Re: Strange behavior between timestamp and date comparison

2022-07-24 Thread Rory Campbell-Lange
On 23/07/22, Ludwig Isaac Lim (ludz_...@yahoo.com) wrote: > Below is a sample case that exhibits a behavior that I can't explain: > > -- create the table > create table ts (t timestamp without time zone); > > -- populate > insert into ts(t) values ('2022-07-16 00:22:06.974000'); > insert into ts(

Strange behavior between timestamp and date comparison

2022-07-24 Thread Ludwig Isaac Lim
Hello: Below is a sample case that exhibits a behavior that I can't explain: -- create the table create table ts (t timestamp without time zone); -- populate insert into ts(t) values ('2022-07-16 00:22:06.974000'); insert into ts(t) values ('2022-07-16 00:22:06.974000'); insert into ts(t) values