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