Re: Index on geometry and timestamp

The Problem is, that I need the milliseconds and the information of the
Timezone.

-----Ursprüngliche Nachricht-----
Von: Pierre-Frédéric Caillaud [mailto:lists(at)boutiquenumerique(dot)com]
Gesendet: Dienstag, 7. Dezember 2004 09:48
An: Werdin Jens; pgsql-general(at)postgresql(dot)org
Betreff: Re: [GENERAL] Index on geometry and timestamp

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 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 problem?
>
> Greetings
> Jens
>