The following bug has been logged on the website:

Bug reference:      6424
Logged by:          Olaf
Email address:      o(dot)bousche(at)krohne(dot)com
PostgreSQL version: 9.1.2
Operating system:   Windows 7 - 64bits
Description:        

Should the query

select
  extract(epoch
    from cast('2012-01-01 14:30:1' as
             timestamp) -
         cast('1970-01-01 0:0:0' as
              timestamp))) - 
  extract(epoch
    from (cast('2012-01-01 14:30:1' as
              timestamp)))

return 0 instead of 3600?

Responses

• Re: BUG #6424: Possible error in time to seconds conversion at 2012-02-01 16:00:25 from Tom Lane

pgsql-bugs by date

Next:	From: postgres	Date: 2012-02-01 14:28:30
	Subject: BUG #6425: Bus error in slot_deform_tuple
Previous:	From: Tom Lane	Date: 2012-02-01 04:47:11
	Subject: Re: Fw: Re: [SQL] pg_dump not correctly saving schema with partitioned tables?