Re: Cast null string '' to integer 0

Поиск
Список
Период
Сортировка
От Guy Rouillier
Тема Re: Cast null string '' to integer 0
Дата
Msg-id D4D1632DC736E74AB95FE78CD609007923B03A@mtxexch01.add0.masergy.com
обсуждение исходный текст
Ответ на Cast null string '' to integer 0  ("Dwight Emmons" <demmons@instantbenefits.com>)
Ответы Re: Cast null string '' to integer 0
Список pgsql-general
Dwight Emmons wrote:
> I am upgrading from Postgres 7.2 to 8.1.  We have multiple systems
> already in place that took advantage of the implicit cast of a null
> '' string to an integer of '0'.  It is not financially feasible for
> us to modify all the instances.  Does anyone know of a fix?

Well, if you want all your clients to interpret a null value in that
column as zero, can't you just update the column to actually contain a
zero for those rows?

--
Guy Rouillier

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

Предыдущее
От: John Gunther
Дата:
Сообщение: Locale, encoding, sort order confusion
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: text formatting in a query, a la sprintf