Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Adriaan van Os <postgres(at)microbizz(dot)nl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2905: min and max return incorrect text type
Date: 2007-01-19 15:49:33
Message-ID: 200701191549.l0JFnXv05585@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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. +

In response to

Responses

pgsql-bugs by date

Next:From: Adriaan van OsDate: 2007-01-19 16:01:33
Subject: Re: BUG #2905: min and max return incorrect text type
Previous:From: Roman NowakDate: 2007-01-19 14:50:24
Subject: BUG #2913: Subscript on multidimensional array yields no value

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group