Re: BUG #2905: min and max return incorrect text type - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #2905: min and max return incorrect text type
Date
Msg-id 200701211332.38374.peter_e@gmx.net
Whole thread Raw
In response to Re: BUG #2905: min and max return incorrect text type  (Adriaan van Os <postgres@microbizz.nl>)
Responses Re: BUG #2905: min and max return incorrect text type  (Bruce Momjian <bruce@momjian.us>)
Re: BUG #2905: min and max return incorrect text type  (Adriaan van Os <postgres@microbizz.nl>)
List pgsql-bugs
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/

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #2908: ISO8601 Date / Time Format Incompatibility
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #2905: min and max return incorrect text type