Hi
I am using 9.1.6, and I've set up a partitioned table as described in the manual, with partitions based on a timestamptz column called 'time'. The exclusion constraints work nicely when I select ranges of times with literal constants. But why would a WHERE clause like the following not benefit from exclusion constraints?
time > TIMESTAMPTZ '2012-11-03 00:00:00Z' + INTERVAL '24 hours'
Isn't that expression on the right reducible to a constant up front? Obviously I can use a host language to do the arithmetic and provide a constant, but I am curious to understand why that wouldn't be constant-folded.
Thanks
Thomas