clarification of timestamp

From: Olivier PRENANT <ohp(at)pyrenet(dot)fr>
To: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: clarification of timestamp
Date: 2002-04-29 15:14:20
Message-ID: Pine.UW2.4.21.0204291708570.29577-100000@server.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I've already posted, a few weeks ago a concern about timestamp and
indices.

My problem was that on my 7.1.3 db, I have timestamp columns with
fonctinal indices as date(column).

Thes indices (indexes) wont work anymore because they're not marked loosy.

I've been told that I should go for timestamp without timezone instead,
witch is okay because all timezones are the same. However, what happens
with daylight saving calculations. Is it still take into account??

Many thaks for that great product!

Regards

--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-04-29 15:25:11 Re: pid gets overwritten in OSX
Previous Message Scott Marlowe 2002-04-29 15:09:54 Re: Vote totals for SET in aborted transaction