Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.

"Dirk Heinrichs" <dirk(dot)heinrichs(at)altum(dot)de> writes:
> The moddatetime function provided by this module only works on columns of
> type "timestamp without time zone". Would be nice if it could also provide
> an analogous function moddatetime_tz which provides the same functionality
> for columns of type "timestamp with time zone".

dim=# select pg_typeof('now'::timestamp), pg_typeof('now'::timestamptz);
pg_typeof | pg_typeof
-----------------------------+--------------------------
timestamp without time zone | timestamp with time zone
(1 row)

So I guess that you need to modify very little code to get the trigger
to work for both types.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support