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@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.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

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