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

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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Adriaan van Os <postgres(at)microbizz(dot)nl>, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: BUG #2905: min and max return incorrect text type
Date: 2007-01-21 12:32:37
Message-ID: 200701211332.38374.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Adriaan van Os wrote:
> >> However, min(VARCHAROID) and max(VARCHAROID) return TEXTOID as a
> >> result type.
> >
> > Yea, they are internally treated as very similar types.
>
> But "internally treated as very similar" is still not "same as
> argument type". Computing requires exactness.

Aside from the apparent discrepancy between the documentation and the 
actual behavior, is there an actual use case where this is a problem?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

pgsql-bugs by date

Next:From: Adriaan van OsDate: 2007-01-21 13:42:37
Subject: Re: BUG #2905: min and max return incorrect text type
Previous:From: Peter EisentrautDate: 2007-01-21 12:29:02
Subject: Re: BUG #2908: ISO8601 Date / Time Format Incompatibility

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