Cc: [EMAIL PROTECTED]
> Betreff: Re: [GENERAL] 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
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 pro
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 and
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
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 solv
