Error in 7.2 - Mailing list pgsql-hackers

From rbt@barchord.com
Subject Error in 7.2
Date
Msg-id 20020116142651.A38977@fury.inquent.com
Whole thread Raw
Responses Re: Error in 7.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
select now() + cast('71 minutes' as interval) as case1     , cast('71 minutes' as interval) + now() as case2     ,
now()+ cast('5 minutes' as interval) as case3     , cast('5 minutes' as interval) + now() as case4     , now();
 


The above works as expected in 7.1, but in 7.2 case1 and case2 have 
different values.  Appears hours to seconds are ignored if it's 
interval + timestamp rather than timestamp + interval.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: tuptoaster.c must *not* use SnapshotAny
Next
From: Kovacs Zoltan
Date:
Subject: Re: backend/po, make update-po works strange