Re: Is there anyway to create a functional index using to_date?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is there anyway to create a functional index using to_date?
Дата
Msg-id 10494.1124247766@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Is there anyway to create a functional index using to_date?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-admin
Bruno Wolff III <bruno@wolff.to> writes:
> Chris Hoover <revoohc@gmail.com> wrote:
>> I can get it to create on if I create a special function that just
>> takes the field to be converted and returns the converted date.

> That is what you have to do in older versions of postgres. You don't have
> to do that in 8.0 (I am not sure about 7.4).

7.4 does it too.  7.3 is ... um ... old.

            regards, tom lane

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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: GRANT ALL PRIVILEGES ON DATABASE
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: SQL Help - Obtaining ID of record INSERTED