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