Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> timestamptz + interval is not immutable --- in fact, the particular
>> example you give (ts + '1 day') is certainly dependent on timezone
> Why not? Given that the time zone will be the same for both the
> timestamptz and the interval, how would the result not be immutable?
The reason it depends on the timezone is that the result varies if
"plus one day" means crossing a DST boundary.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Pavel Stehule||Date: 2011-04-21 06:01:54|
|Subject: Re: %100 CPU on Windows Server 2003|
|Previous:||From: Josh Berkus||Date: 2011-04-21 02:18:23|
|Subject: Re: Constraint exclusion can't process simple constant