Re: [HACKERS] clarification of timestamp

2002-04-29 Thread Olivier PRENANT
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 leav

Re: [HACKERS] clarification of timestamp

2002-04-29 Thread Thomas Lockhart
> 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

[HACKERS] clarification of timestamp

2002-04-29 Thread Olivier PRENANT
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 fo