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

Adriaan van Os wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2905
> Logged by: Adriaan van Os
> Email address: postgres(at)microbizz(dot)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.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +