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,
pgsql-admin by date
|Next:||From: Bruno Wolff III||Date: 2005-08-16 21:07:01|
|Subject: Re: Is there anyway to create a functional index using to_date?|
|Previous:||From: Chris Hoover||Date: 2005-08-16 17:36:19|
|Subject: Re: Any way to see what queries are currently running?|