[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 appreciated

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 would

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? Well,

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