Alessandro Gagliardi <alessandro@xxxxxxxx> wrote: > hr_timestamp timestamp without time zone, In addition to the responses which more directly answer your question, I feel I should point out that this will not represent a single moment in time. At the end of Daylight Saving Time, the value will jump backward and you will run through a range of time which will overlap existing entries. There is almost never a good reason to use TIMESTAMP WITHOUT TIME ZONE -- TIMESTAMP WITH TIME ZONE is required if you want the value to represent a moment in time. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
