BUG #5728: Unexpected behavior comparing result of age() to an interval

Поиск
Список
Период
Сортировка
От Dobes Vandermeer
Тема BUG #5728: Unexpected behavior comparing result of age() to an interval
Дата
Msg-id 201010262145.o9QLjZ2k097528@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5728: Unexpected behavior comparing result of age() to an interval
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5728
Logged by:          Dobes Vandermeer
Email address:      dobes.vandermeer@kashoo.com
PostgreSQL version: 8.4
Operating system:   Windows
Description:        Unexpected behavior comparing result of age() to an
interval
Details:

Seeing some surprising behavior with the use of age() and comparing the
result to an interval:

select current_date,
       age(current_date - interval '123 days') <= interval '120 days',
       age(current_date - interval '122 days') <= interval '120 days',
       age(current_date - interval '121 days') <= interval '120 days',
       age(current_date - interval '120 days') <= interval '120 days',
       age(current_date - interval '62 days') <= interval '60 days',
       age(current_date - interval '61 days') <= interval '60 days',
       age(current_date - interval '60 days') <= interval '60 days',
       age(current_date - interval '30 days') <= interval '30 days';


Returns:

"2010-10-26";f;t;t;t;f;t;t;t

But I expected:

"2010-10-26";f;f;f;t;f;f;t;t

Something fishy there ...

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: BUG #5727: Indexes broken in streaming replication
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5728: Unexpected behavior comparing result of age() to an interval