Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 29 Apr 2002 17:14:20 +0200 (MET DST)
- Message-id: <Pine.UW2.4.21.0204291708570.29577-100000@server.pyrenet.fr> <text/plain>
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)
- Follow-Ups:
- Re: clarification of timestamp
- From: Thomas Lockhart
- Re: clarification of timestamp
- Prev by Date: Re: Vote totals for SET in aborted transaction
- Next by Date: Re: Vote totals for SET in aborted transaction
- Previous by thread: GSSAPI/Kerberos
- Next by thread: Re: clarification of timestamp
- Indexes: