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