Re: max() unexpected type conversion

Поиск
Список
Период
Сортировка
От Hélder M. Vieira
Тема Re: max() unexpected type conversion
Дата
Msg-id 002a01c5ef05$da3bbc30$6200a8c0@hmv02
обсуждение исходный текст
Ответ на max() unexpected type conversion  (Hélder M. Vieira <hmv@mail.telepac.pt>)
Список pgsql-sql
> This is true of just about everything, not only max() -- there are *no*
> functions yielding varchar in recent PG releases

Thanks for the information. I added an explicit cast to the max() output and
it works fine.

Anyway, for those using VB, this is potentially hazardous. Knowing that the
underlying data is of type 'varchar', one has to be always very cautious
about the 'text' conversion, otherwise all readings after the first will
return null instead of valid data.



Helder M. Vieira




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

Предыдущее
От: george young
Дата:
Сообщение: Re: tid_le comparison for tuple id (ctid) values?
Следующее
От: Samer Abukhait
Дата:
Сообщение: Re: Please help to wite the constraint.