Cast null string '' to integer 0

From: "Dwight Emmons" <demmons(at)instantbenefits(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Cast null string '' to integer 0
Date: 2006-08-17 21:06:51
Message-ID: 20060817210643.YCUQ28427.mta10.adelphia.net@IBN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabio Victora Hecht 2006-08-17 21:12:31 count and limit
Previous Message Alexander Farber 2006-08-17 21:02:42 select * from users where user_id NOT in (select ban_userid from banlist)