[GENERAL] Cast null string '' to integer 0

2006-08-19 Thread 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 apprec

Re: [GENERAL] Cast null string '' to integer 0

2006-08-19 Thread Bruce Momjian
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? You wo

Re: [GENERAL] Cast null string '' to integer 0

2006-08-19 Thread Guy Rouillier
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? Wel

Re: [GENERAL] Cast null string '' to integer 0

2006-08-19 Thread Berend Tober
Guy Rouillier wrote: 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 kn