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 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. > > 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 > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
