we found the problem:
We used IMMUTABLE modifier in our CREATE FUNCTION definition,
though it's correct for our function to return same value if input the
same *data*,
but our data are passed by reference, not by value, so, some times we can't
retrive out data. Remove IMMUTABLE fixed the problem.
So, it seems to make it clear in docs would be a good help to function
writers,
would commit a documentation patch later if necessary.
Thank you!
Regards
Laser
Tom Lane wrote:
>Weiping He <laser@zhengmai.com.cn> writes:
>
>
>> the situation trun worse: now the explain shows the query using the
>>index,
>> the we can't select out the match row! Any hint about what's wrong
>>with us?
>>
>>
>
>My bet: either your operators are broken or your operator class
>definition is wrong.
>
> regards, tom lane
>
>
>