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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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