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

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 (view raw or flat)
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

pgsql-bugs by date

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

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