Tom Lane wrote:
"Steve Clark" <[EMAIL PROTECTED]> writes:
Until 8.3.0 the following worked:
SELECT coalesce(param_value,chr(0)) from t_system_params where param_name =
'default_unit_key';
It would have "worked" only for rather small values of "work", since
most of the support for type TEXT isn't null-safe. Try something like
"select chr(0) || 'foo';" for example. Wouldn't an empty string do what
you want better?
it now fails with:
ERROR: null character not permitted
This is an intentional change and won't be undone, at least not until
TEXT is null-safe, which isn't likely to happen in the foreseeable future.
regards, tom lane
Hi Tom,
I'm not sure. This was written in 2001/2002 timeframe and I inherited
it. I am not even sure what he was
trying to accomplish.
I'm not sure I understand what you mean about TEXT being null-safe.
What are the issues, and why was
it supported for years and now abruptly changed.
All I know is the code used to work from 7.3.x up through 8.2.5 and
now it doesn't.
If it not going the made to work according to the documentation then
the documentation should be
fixed.
Steve
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-bugs
