Re: Index on geometry and timestamp

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: "Werdin Jens" <jens(dot)werdin(at)siemens(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Index on geometry and timestamp
Date: 2004-12-07 08:47:56
Message-ID: opsimqp614cq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Werdin Jens 2004-12-07 08:55:42 Re: Index on geometry and timestamp
Previous Message Per Jensen 2004-12-07 08:37:18 Re: Index scan vs. Seq scan on timestamps