WG: AW: Index on geometry and timestamp

Thank you Oleg,

It works.

glad to hear that. You might submit this to posgis faq.

Greetings
Jens

-----Urspr?ngliche Nachricht-----
Von: Oleg Bartunov [mailto:oleg@sai.msu.su]
Gesendet: Dienstag, 7. Dezember 2004 12:20
An: Werdin Jens
Cc: pgsql-general@postgresql.org
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 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

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