On Mon, Mar 20, 2006 at 17:40:03 -0500, Tom Lane <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match