Re: Index on geometry and timestamp - Mailing list pgsql-general

From Pierre-Frédéric Caillaud
Subject Re: Index on geometry and timestamp
Date
Msg-id opsimqp614cq72hf@musicbox
Whole thread Raw
In response to Index on geometry and timestamp  (Werdin Jens <jens.werdin@siemens.com>)
List pgsql-general

    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
>



pgsql-general by date:

Previous
From: Daniel Martini
Date:
Subject: Re: When to encrypt
Next
From: Werdin Jens
Date:
Subject: Re: Index on geometry and timestamp