[GENERAL] Cast null string '' to integer 0

[Dwight Emmons]

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?   Any help would be appreciated   Dwight