] Index on geometry and timestamp
On Tue, 7 Dec 2004, Werdin Jens wrote:
Hi,
I need an index on a postgis-point and a timestamp.
I'm using an GiST index on the geometry. But the creation of an GiST
index
on geometry and timestamp seems to be impossible, because GiST doesn't
support Timestamps
You could convert your timestamp into an integer (number of seconds since
the epoch).
Also, under certain conditions, you can cheat and use a sequence instead
of a timestamp.
Hi,
I need an index on a postgis-point and a timestamp.
I'm using an GiST index on the geometry. But the creation
The Problem is, that I need the milliseconds and the information of the
Timezone.
-Ursprüngliche Nachricht-
Von: Pierre-Frédéric Caillaud [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 7. Dezember 2004 09:48
An: Werdin Jens; [EMAIL PROTECTED]
Betreff: Re: [GENERAL] Index on geometry
On Tue, 7 Dec 2004, Werdin Jens wrote:
Hi,
I need an index on a postgis-point and a timestamp.
I'm using an GiST index on the geometry. But the creation of an GiST index
on geometry and timestamp seems to be impossible, because GiST doesn't
support Timestamps.
Is there a possibility to solve my
Title: Index on geometry and timestamp
Hi,
I need an index on a postgis-point and a timestamp.
I'm using an GiST index on the geometry. But the creation of an GiST index on geometry and timestamp seems to be impossible, because GiST doesn't support Timestamps.
Is there a possibility to