Re: [BUGS] BUG #5728: Unexpected behavior comparing result of age() to an interval

2010-10-26 Thread Tom Lane
"Dobes Vandermeer" writes: > 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',

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

2010-10-26 Thread Dobes Vandermeer
The following bug has been logged online: Bug reference: 5728 Logged by: Dobes Vandermeer Email address: dobes.vanderm...@kashoo.com PostgreSQL version: 8.4 Operating system: Windows Description:Unexpected behavior comparing result of age() to an interval Details: S