[GENERAL] ERROR: DefineIndex: index function must be marked iscachable

[Elielson Fontanezi]

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
---------------------------(    )----------(    )--------------------------------
                            \  (            )  /
                             \_/            \_/