><[EMAIL PROTECTED]> writes:
>> CREATE INDEX request_day_idx ON moksha_sm_request >(date_trunc('day',
>request_received));
>...
>> I'd be grateful if someone could point out what part of the statement >is not
>> IMMUTABLE or how I could mark my create index statement as being >immutable.
>date
Hi,
is is possible to create an expression index based on the date_trunc function?
Working with PostgreSQL 8.2, I'm trying to create an index using:
CREATE INDEX request_day_idx ON moksha_sm_request (date_trunc('day',
request_received));
I get the error message:
ERROR: functions in index
