BUG #2905: min and max return incorrect text type

From: "Adriaan van Os" <postgres(at)microbizz(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2905: min and max return incorrect text type
Date: 2007-01-18 09:02:12
Message-ID: 200701180902.l0I92CUw088927@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Adriaan van Os 2007-01-18 10:35:18 BUG #2906: slow windows network performance
Previous Message Izsak Rudolf 2007-01-17 23:39:20 BUG #2904: COPY FROM -> permisson denied