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

Bruce Momjian wrote:
> Adriaan van Os wrote:
>> The following bug has been logged online:
>>
>> Bug reference:      2905
>> Logged by:          Adriaan van Os
>> Email address:      postgres@microbizz.nl
>> PostgreSQL version: 8.1.4
>> Operating system:   Mac OS X 10.4.6, intel
>> Description:        min and max return incorrect text type
>> Details:
>>
>> Table 9-37. Aggregate Functions in the Postgres docs states that the return
>> type for min and max is the "same as argument type".
>>
>> 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.

Adriaan van OS