Joshua Moore-Oliva <josh(at)chatgris(dot)com> writes:
> The problem I am having is when I attempt to convert a timestamp with a time
> zone to another time zone. For example, the statement
> SELECT now() AT TIME ZONE interval '-5 hours'
> returns type interval not timestamp with//out time zone.
This appears to be a simple typo in the pg_proc entry for the function.
The underlying C code thinks it is returning a timestamp without time
zone, but that's not what the pg_proc entry has.
You can fix this in an existing database by doing
UPDATE pg_proc SET prorettype = 1114 WHERE prosrc = 'timestamptz_izone';
regards, tom lane