BAndrew Dunstan wrote:
>
>
> Bruce Momjian wrote:
> > Tom Lane wrote:
> >
> >> Steve Clark <sclark@netwolves.com> writes:
> >>
> >>> 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.
> >>>
> >> It never was supported, we are simply plugging a hole that let you
> >> create a text value that would be likely to malfunction in subsequent
> >> use.
> >>
> >
> > Seems we never documented that chr(0) is not supported. I have applied
> > the following doc patch to CVS HEAD and 8.3.X.
> >
> >
> > The NULL (0) character is not
> > allowed because text data types cannot reliably store such bytes.
> >
> >
>
>
>
> "Reliably" is arguably misleading here.
Agreed. "Reliably" word removed.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +