On Mon, Feb 14, 2000 at 11:00:16AM -0500, Tom Lane wrote:
> Patrick Welche <prlw1@newn.cam.ac.uk> writes:
>
> > + if (!string)
> > + elog(ERROR, "Trying to convert NULL text to integer (int2)");
>
> This is unreasonable behavior. The correct patch is just
>
> if (!string)
> return 0;
>
> which will allow the function manager to plow ahead with returning the
> NULL that it's going to return anyway. See the past pghackers threads
> about redesigning the function manager interface if you don't understand
> what's going on here.
Off top of head, that means that null and the string "0" both return 0..
OK - I'll look for the mail thread.
Cheers,
Patrick