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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-bugs(at)postgresql(dot)org, Adriaan van Os <postgres(at)microbizz(dot)nl>
Subject: Re: BUG #2905: min and max return incorrect text type
Date: 2007-01-21 18:17:13
Message-ID: 27858.1169403433@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Peter Eisentraut wrote:
>> Aside from the apparent discrepancy between the documentation and the
>> actual behavior, is there an actual use case where this is a problem?

> No, I don't think so, and I am reluctant to adjust the documentation to
> say "or similar".

The documentation is correct as it stands: max(text) returns text.
Adriaan's complaint about max(varchar) is off base because there is
no such function.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2007-01-21 23:37:03 Re: BUG #2905: min and max return incorrect text type
Previous Message Maarten van der Heijden 2007-01-21 17:36:31 Re: Troubles in Initializing Postgres Database 8.2