Strange behavior between timestamp and date comparison

Поиск
Список
Период
Сортировка
От Ludwig Isaac Lim
Тема Strange behavior between timestamp and date comparison
Дата
Msg-id 1485906141.916850.1658570664512@mail.yahoo.com
обсуждение исходный текст
Ответы Re: Strange behavior between timestamp and date comparison  (Rory Campbell-Lange <rory@campbell-lange.net>)
Re: Strange behavior between timestamp and date comparison  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
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 ('2022-07-16 00:22:06.974000');



-- This one return expected results
select * from ts where t::date between '2022-07-16'::Date - make_interval(days => 30) and '2022-07-16'::Date;
            t
-------------------------
 2022-07-16 00:22:06.974
 2022-07-16 00:22:06.974
 2022-07-16 00:22:06.974
(3 rows)


-- This one doesn't return anything (unexpected)
 select * from ts where t between '2022-07-16'::Date - make_interval(days => 30) and '2022-07-16'::Date;
 t
---
(0 rows)

-- version
select version();
                                                 version
---------------------------------------------------------------------------------------------------------
 PostgreSQL 14.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-15), 64-bit
(1 row)



Regards,
Ludwig Lim




В списке pgsql-general по дате отправления:

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Logical replication versus pglogical on PostgreSQL 14
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: 20220722-pg_dump: error: invalid number of parents 0 for table