X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7ED8A9DC9C6 for ; Mon, 20 Mar 2006 18:40:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92782-07 for ; Mon, 20 Mar 2006 18:40:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 958319DC9C1 for ; Mon, 20 Mar 2006 18:40:12 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k2KMe3aO008489; Mon, 20 Mar 2006 17:40:03 -0500 (EST) To: Alvaro Herrera cc: Achilleus Mantzios , Peter Eisentraut , "Eugene E." , pgsql-sql@postgresql.org Subject: Re: have you feel anything when you read this ? In-reply-to: <20060320121354.GA12564@surnet.cl> References: <200603201251.11255.peter_e@gmx.net> <20060320121354.GA12564@surnet.cl> Comments: In-reply-to Alvaro Herrera message dated "Mon, 20 Mar 2006 08:13:54 -0400" Date: Mon, 20 Mar 2006 17:40:03 -0500 Message-ID: <8488.1142894403@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.113 required=5 tests=[AWL=0.113] X-Spam-Score: 0.113 X-Spam-Level: X-Archive-Number: 200603/315 X-Sequence-Number: 24661 Alvaro Herrera writes: > text is not bytea. 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.) regards, tom lane