CREATE INDEX function limitation - Mailing list pgsql-general

In a CREATE INDEX statement, functions don't do type conversion and
can't be nested, meaning that the cast convertion function won't work.

So,

CREATE INDEX testidx on testtable (upper(CAST colname AS TEXT));

fails.  Is this a feature I should just work around?

Using 7.0.3-2

--
Bruce