Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group