erobles <erobles@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general