ALTER TYPE 4: temporal data types

Noah Misch <noah@leadboat.com>

From: Noah Misch <noah@leadboat.com>
To: pgsql-hackers@postgresql.org
Date: 2011-01-09T22:05:00Z
Lists: pgsql-hackers

Attachments

Add exemptor functions to avoid rewrites for conversions involving the temporal
data types.  I needed a find-last-set function for the interval_scale exemptor
function, so I imported one from FreeBSD.  To improve timestamp<->timestamptz
when the timezone "is" UTC/GMT, I compare the current timezone definition to the
gmt_timezone we keep handy.  To make that actually work, I've changed pg_tzset
to zero its unused bytes.