From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Another nasty cache problem |
Date: | 2000-02-14 16:14:44 |
Message-ID: | 20000214161444.D13823@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Feb 14, 2000 at 11:00:16AM -0500, Tom Lane wrote:
> Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-02-14 16:50:36 | Programmers needed to implement Replication ... |
Previous Message | Tom Lane | 2000-02-14 16:00:16 | Re: [HACKERS] Another nasty cache problem |