Search Postgresql Archives

Re: Cast null string '' to integer 0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux