Hi all!
What can I do in this case?
I could not found anything about iscachable.
postgres$ cat in.sql
create index bt_proposta_f01 on proposta
using btree (func_cod_secretaria(nr_proponente));
postgres$ psql -d escola -f in.sql
psql:in.sql:2: ERROR: DefineIndex: index function must be marked iscachable
postgres$
>\\\!/< 55 11 5080 9283
!_"""_! Elielson Fontanezi
(O) (o) PRODAM - Technical Support Analyst
-------------------------------oOOO--(_)--OOOo-----------------------------------
Success usually comes to those who are too busy to be looking for it.
oooo0 0oooo
---------------------------( )----------( )--------------------------------
\ ( ) /
\_/ \_/