Simon Riggs <si...@2ndquadrant.com> writes:
> Why is bcTruelen being called so many *more* times?
I think you have misunderstood the context. The char(n) code is defined
to store trailing blanks (up to n) but to disregard the trailing blanks
during comparisons. bcTrueLen is invoked during comparisons (not during
storage) to figure out what the "valid" string length is for comparing.
varchar considers any trailing blanks to be real, comparable data,
so it simply hasn't got any equivalent code.
It would be way nicer if we could strip trailing blanks on storage,
and then figure a way to either reconstitute them on output (problem
here is the output function doesn't have access to typmod) or
language-lawyer our way to deciding we don't have to.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
