Re: how can i mark date function like iscachable

Hello

2009/8/3 erobles <erobles(at)sensacd(dot)com(dot)mx>:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>