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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: BUG #2905: min and max return incorrect text type
Дата
Msg-id 200701211332.38374.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: BUG #2905: min and max return incorrect text type  (Adriaan van Os <postgres@microbizz.nl>)
Ответы Re: BUG #2905: min and max return incorrect text type  (Bruce Momjian <bruce@momjian.us>)
Re: BUG #2905: min and max return incorrect text type  (Adriaan van Os <postgres@microbizz.nl>)
Список 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/

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #2908: ISO8601 Date / Time Format Incompatibility
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #2905: min and max return incorrect text type