Jesse Scott <scotje@wwc.edu> writes:
>> Ok, I was actually dyslexic when I read the version number, I have
>> 7.3.2 not 7.2.3, I'll investigate the timezone status though.
In that case I think you are looking for this 7.3.3 fix:
2003-02-27 16:37 tgl
* src/backend/utils/adt/timestamp.c (REL7_3_STABLE): ChangeEXTRACT(EPOCH FROM timestamp) so that a timestamp without
timezoneis assumed to be in local time, not GMT. This improves consistencywith other operations, which all assume
localtimezone when itmatters. Per bug #897.
regards, tom lane