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 <[EMAIL PROTECTED]> 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






---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to