Re: Cast null string '' to integer 0

From: "Guy Rouillier" <guyr(at)masergy(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cast null string '' to integer 0
Date: 2006-08-19 22:38:19
Message-ID: D4D1632DC736E74AB95FE78CD609007923B03A@mtxexch01.add0.masergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-08-19 22:50:08 Re: text formatting in a query, a la sprintf
Previous Message John Gunther 2006-08-19 22:37:32 Locale, encoding, sort order confusion