Hello 2009/8/3 erobles <erobles@xxxxxxxxxxxxxx>: > another thing i tried to do was: > > create or replace function lafecha(timestamp with time zone) returns date > as 'select date($1);' > language 'SQL' > with iscachable; > try to use IMMUTABLE Pavel > > But i got the message: ERROR parser: parse error at or near "iscachable"; > if avoid "with iscachable" string the fucntion was created succesfully. > > > erobles wrote: >> >> erobles wrote: >>> >>> Hello there! >>> >>> 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. >>> >>> So, How can i mark the date function iscachable ? :-) >>> >>> i hope your anwsers, anyway thanks to read this ! >>> >>> >>> >> >> > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
