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 solve my problem?
Greetings
Jens
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.
Show quoted text
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
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@boutiquenumerique.com]
Gesendet: Dienstag, 7. Dezember 2004 09:48
An: Werdin Jens; pgsql-general@postgresql.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.
Show quoted text
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
Import Notes
Resolved by subject fallback
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 problem?
yes, use contrib/btree_gist
Greetings
Jens
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83