Postgres Pro
Downloads
Home   >   mailing lists

BUG #5966: extract(epoch..) function error - Mailing list pgsql-bugs

From Ricardo Solanilla
Subject BUG #5966: extract(epoch..) function error
Date
Msg-id 201104062317.p36NHgAR084504@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5966: extract(epoch..) function error  (Joshua Tolley <eggyknap@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      5966
Logged by:          Ricardo Solanilla
Email address:      info@abaco-tandil.com.ar
PostgreSQL version: 8.3.0  b.1400
Operating system:   windows nt
Description:        extract(epoch..) function error
Details:

-- try this

select (extract(epoch from (date('2011-03-20'))) - extract(epoch from
(date('2011-03-19')))) / 3600

-- it must be 24 (hours), only occurs in march 19,2011
-- in v. 8.0 work fine!!

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #5965: PostgreSQL crashes during connection
Next
From: Brendan Jurd
Date:
Subject: Failed assert ((data - start) == data_size) in heaptuple.c