Re: Index on geometry and timestamp

Поиск
Список
Период
Сортировка
От Pierre-Frédéric Caillaud
Тема Re: Index on geometry and timestamp
Дата
Msg-id opsimqp614cq72hf@musicbox
обсуждение исходный текст
Ответ на Index on geometry and timestamp  (Werdin Jens <jens.werdin@siemens.com>)
Список 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
>



В списке pgsql-general по дате отправления:

Предыдущее
От: Daniel Martini
Дата:
Сообщение: Re: When to encrypt
Следующее
От: Werdin Jens
Дата:
Сообщение: Re: Index on geometry and timestamp