From: | Weiping He <laser(at)zhengmai(dot)com(dot)cn> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Wang Mike <itlist(at)msn(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: a problem with index and user define type |
Date: | 2003-06-24 05:11:33 |
Message-ID: | 3EF7DD85.4020000@zhengmai.com.cn |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)zhengmai(dot)com(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2003-06-24 05:14:36 | Re: Two weeks to feature freeze |
Previous Message | Jan Wieck | 2003-06-24 05:09:56 | Re: Two weeks to feature freeze |