Re: Cast null string '' to integer 0 - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Cast null string '' to integer 0
Date
Msg-id D4D1632DC736E74AB95FE78CD609007923B03A@mtxexch01.add0.masergy.com
Whole thread Raw
In response to Cast null string '' to integer 0  ("Dwight Emmons" <demmons@instantbenefits.com>)
Responses Re: Cast null string '' to integer 0
List 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 by date:

Previous
From: John Gunther
Date:
Subject: Locale, encoding, sort order confusion
Next
From: Michael Fuhr
Date:
Subject: Re: text formatting in a query, a la sprintf