Error in 7.2

From: rbt(at)barchord(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: Error in 7.2
Date: 2002-01-16 19:26:51
Message-ID: 20020116142651.A38977@fury.inquent.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-01-16 19:55:46 Re: again on index usage
Previous Message Tom Lane 2002-01-16 18:30:30 Re: tuptoaster.c must *not* use SnapshotAny