Re: [8.1.4] Create index on timestamp fails - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: [8.1.4] Create index on timestamp fails
Date
Msg-id 20060823132356.GH5940@merkur.hilbert.loc
Whole thread Raw
In response to Re: [8.1.4] Create index on timestamp fails  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: [8.1.4] Create index on timestamp fails  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: How do i store arbitrary questions and answers in SQL?
Next
From: Don Isgitt
Date:
Subject: Re: pl/R problem