Re: BUG #2905: min and max return incorrect text type - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #2905: min and max return incorrect text type
Date
Msg-id 200701211443.l0LEhrv24550@momjian.us
Whole thread Raw
In response to Re: BUG #2905: min and max return incorrect text type  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: BUG #2905: min and max return incorrect text type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Peter Eisentraut wrote:
> 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?

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

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #2905: min and max return incorrect text type
Next
From: Magnus Hagander
Date:
Subject: Re: Troubles in Initializing Postgres Database 8.2