Re: Cast null to int4 upgrading from Version 7.2 - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: Cast null to int4 upgrading from Version 7.2
Date
Msg-id 200611170722.00942.peter_e@gmx.net
Whole thread Raw
In response to Re: Cast null to int4 upgrading from Version 7.2  (Jim Nasby <decibel@decibel.org>)
List pgsql-patches
Jim Nasby wrote:
> As a less invasive alternative, I *think* you could create an SQL
> function for casting text to int that treated '' as 0, and then
> replace the built-in CAST with that.

Won't work.  You need to replace the data type input function.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-patches by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Cast null to int4 upgrading from Version 7.2
Next
From: Mario Weilguni
Date:
Subject: Re: Cast null to int4 upgrading from Version 7.2