>Indeed ... *please* tell us your compiler issued a warning about that.

I did shell scripts that suppress the warnings, so it was a big mistake, I
agree! But I think my problem is not here!

> Well, you oughta allocate result before you store into it, not after,
> and I bet you meant to assign to the tvi and tvf fields, not tvi twice.

 You are right again. But this happened because I copy and paste the example
with a different order. But in my code all this is ok!

>Bad as these mistakes are, they don't directly explain why a later index
>entry creation would fail.  What I'm betting is that your CREATE TYPE
>command does not correctly describe the datatype size.  Based on this
>code it should be pass-by-reference, fixed-size-8-bytes, but I'll bet
>a nickel your CREATE TYPE says something else --- probably varlena.

Humm, this can help! I will investigate! Thanks a lot!

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to