erobles <erob...@sensacd.com.mx> writes: >> i tried to create an functional index like this: >> create index estdistfecha on estadist (date(fecha));
>> but only get the next message: >> ERROR: DefineIndex: index function must be marked iscachable. Egad, what are you running? That message hasn't been spelled that way since PG 7.2. Get yourself onto a more modern PG release, before that one eats your data. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general