Re: Constraint exclusion can't process simple constant expressions? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Constraint exclusion can't process simple constant expressions?
Date
Msg-id 4DAF8F60.9050407@agliodbs.com
Whole thread Raw
In response to Re: Constraint exclusion can't process simple constant expressions?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Constraint exclusion can't process simple constant expressions?
Re: Constraint exclusion can't process simple constant expressions?
List pgsql-performance
Tom,

> timestamptz + interval is not immutable --- in fact, the particular
> example you give (ts + '1 day') is certainly dependent on timezone
> setting.

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?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Constraint exclusion can't process simple constant expressions?
Next
From: Brendan Jurd
Date:
Subject: Re: Constraint exclusion can't process simple constant expressions?