From: | Olivier PRENANT <ohp(at)pyrenet(dot)fr> |
---|---|
To: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
Cc: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: clarification of timestamp |
Date: | 2002-04-29 16:46:10 |
Message-ID: | Pine.UW2.4.21.0204291842060.13719-100000@server.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
High Thomas!
Thanks for your reply.
The columns in question are radius start and end of a connection of a
custommer.
Now, it's perfectly valid that start and stop cross a DST bondary in that
case, the duration computed as (stop-start) maybe false.
What do you think?
I'm perfectly OK with leaving time sones on but the table is growing and I
need dates indexes for my statistics.
Hope I made my self clear (i.d pardon my english)
Regards,
On Mon, 29 Apr 2002, Thomas Lockhart wrote:
> > 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??
>
> No, because there is no time zone to think about. What daylight savings
> calculations would you need to consider? I'm a big believer in making
> databases time zone aware, but if everything really is happening within
> the same time zone then your application should probably not notice an
> effect.
>
> - Thomas
>
--
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-29 16:51:07 | Re: Vote totals for SET in aborted transaction |
Previous Message | Bruce Momjian | 2002-04-29 16:45:02 | Re: Vote totals for SET in aborted transaction |