Is there anyway to create a functional index using to_date? - Mailing list pgsql-admin

From Chris Hoover
Subject Is there anyway to create a functional index using to_date?
Date
Msg-id 1d219a6f0508161324285f4ee6@mail.gmail.com
Whole thread Raw
Responses Re: Is there anyway to create a functional index using to_date?  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Chris Hoover
Date:
Subject: Re: Any way to see what queries are currently running?
Next
From: "josh@segrestfarms.com"
Date:
Subject: SQL Help - Obtaining ID of record INSERTED