On Mon, Mar 20, 2006 at 17:40:03 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Indeed. I wonder whether we shouldn't tweak the SQL string literal
> parser to reject \000, because AFAICS that isn't going to do anything
> useful for any datatype, and it leads to what are at best questionable
> results. (bytea's processing of \000 happens somewhere further
> downstream, and wouldn't be affected.)
I think that makes sense. That character is effectively not allowed in text, so
it shouldn't be accepted as input.