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  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: [8.1.4] Create index on timestamp fails  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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
Дата:
Сообщение: Re: How do i store arbitrary questions and answers in SQL?
Следующее
От: Don Isgitt
Дата:
Сообщение: Re: pl/R problem