Jesse Scott <[EMAIL PROTECTED]> 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): Change EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zone is assumed to be in local time, not GMT. This improves consistency with other operations, which all assume local timezone when it matters. Per bug #897. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings