"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes: > As far as I know constraint exclusion doesn't work with date_part or > extract(). Uh, you clipped the example in my message showing that it does, at least in the particular case Kevin showed us. There are some variants of date_part that aren't immutable, but timestamp without tz isn't one of them. Still, I agree that not depending on it would be better. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
