A Gilmore <agilmore@shaw.ca> writes:
> I have table holding timestamps without a time zone (considered GMT).
> Ill being making inserts into this table with a timestamp like 3pm PST,
> which I need to be translated and inserted as GMT. Later this will
> likely be queried where I need the timestamp returned for say EST.
This would all work a lot better if the column were timestamp *with*
timezone. Trying to do it the way you are is just swimming upstream
to no particular purpose.
regards, tom lane