Postgres Pro
Downloads
Home   >   mailing lists

BUG #15545: wrong calculation - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15545: wrong calculation
Date
Msg-id 15545-96bc1bb99d03b6af@postgresql.org
Whole thread Raw
Responses Re: BUG #15545: wrong calculation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15545
Logged by:          Michal C
Email address:      c_michal@poczta.onet.pl
PostgreSQL version: 10.5
Operating system:   Windows
Description:

select extract (epoch from age ('2018-01-31'::date,'2013-01-01'::date) ) /
86400,'2018-01-31'::date-'2013-01-01'::date

first column is wrong calculation

Result:
"column1";"column2"
1856.25;1856

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15544: Unexpected: "Returned record type does not match expected record type" after ALTER TABLE
Next
From: PG Bug reporting form
Date:
Subject: BUG #15546: alter large object n owner to new owner