Gregory Stark <[EMAIL PROTECTED]> writes:
> Teodor Sigaev <[EMAIL PROTECTED]> writes:
>> I'm working on user-defined typmod and try to move all typmod calculations
>> into
>> type-specific functions. But there is a strange place:
> Note that unlike most of the built-in types bpchar doesn't actually make much
> sense without a typmod.
You may be reading too much into it. Looking at the patch that
introduced exprTypmod(), I think I may have just been interested
in avoiding an unnecessary length-coercion function call when assigning
a constant that was already of the correct length to a CHAR(N) column.
I concur with Teodor that embedding this type-specific knowledge into
exprTypmod probably isn't all that great an idea.
regards, tom lane
---------------------------(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
match
