Re: [8.1.4] Create index on timestamp fails

Поиск
Список
Период
Сортировка
Искать
От
Karsten Hilbert
Тема
Re: [8.1.4] Create index on timestamp fails
Дата
Msg-id
20060823132356.GH5940@merkur.hilbert.loc
Ответ на
Список
Дерево обсуждения
Re: [8.1.4] Create index on timestamp fails "Arturo Perez" <aperez@hayesinc.com>
On Wed, Aug 23, 2006 at 09:07:35AM -0400, Alvaro Herrera wrote:

> Another idea would be to separate the date column (which would have the
> index) from the time column (which would have the timezone).  The
> timezone is important -- if you have "bloggers" from all around the
> world you're gonna have serious problems with the archived time.

Would that indeed work ? I mean, depending on the time zone
the *date* might be different by +/-1, too ?

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
В списке pgsql-general по дате отправления
От: Karsten Hilbert
Дата:
От: Don Isgitt
Дата:
Сообщение: Re: pl/R problem
FAQ