Is there anyway to create a functional index using to_date?

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема Is there anyway to create a functional index using to_date?
Дата
Msg-id 1d219a6f0508161324285f4ee6@mail.gmail.com
обсуждение исходный текст
Ответы Re: Is there anyway to create a functional index using to_date?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-admin
I'm running 7.3.4 and we are having problems with our reporting views
on our database.  One fix I wanted to do was to create a functional
index using the to_date function.  However, when I do a create index
abc on table def(to_date(char_field,'yyyymmdd')), PostgreSQL complains
about a parser error at the 'yyyymmdd'.  Is there anyway to force
PostgreSQL to create this kind of index?

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.
However, I would prefer not to go that route since it requires us to
update all of our views.

Thanks for any help,

Chris

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

Предыдущее
От: Chris Hoover
Дата:
Сообщение: Re: Any way to see what queries are currently running?
Следующее
От: "josh@segrestfarms.com"
Дата:
Сообщение: SQL Help - Obtaining ID of record INSERTED