]> granicus.if.org Git - postgresql/commit
Add transform functions for AT TIME ZONE.
authorNoah Misch <noah@leadboat.com>
Sun, 1 Mar 2015 18:22:34 +0000 (13:22 -0500)
committerNoah Misch <noah@leadboat.com>
Sun, 1 Mar 2015 18:22:34 +0000 (13:22 -0500)
commitb8a18ad4850ea5ad7884aa6ab731fd392e73b4ad
treecc80b7675d5c984cde35b7c32bca93b3d7f7e36e
parent424793fa5dc631254f69d5ee8d7d7d6de2976f60
Add transform functions for AT TIME ZONE.

This makes "ALTER TABLE tabname ALTER tscol TYPE ... USING tscol AT TIME
ZONE 'UTC'" skip rewriting the table when altering from "timestamp" to
"timestamptz" or vice versa.  While it would be nicer still to optimize
this in the absence of the USING clause given timezone==UTC, transform
functions must consult IMMUTABLE facts only.
src/backend/utils/adt/timestamp.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/utils/timestamp.h