Re: BUG #2905: min and max return incorrect text type

Adriaan van Os wrote:
> >> However, min(VARCHAROID) and max(VARCHAROID) return TEXTOID as a
> >> result type.
> >
> > Yea, they are internally treated as very similar types.
>
> But "internally treated as very similar" is still not "same as
> argument type". Computing requires exactness.

Aside from the apparent discrepancy between the documentation and the
actual behavior, is there an actual use case where this is a problem?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/