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 C867B9DCAB9 for ; Mon, 20 Mar 2006 07:02:14 -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 49455-06 for ; Mon, 20 Mar 2006 07:02:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moon.antora.ru (moon.antora.ru [83.222.21.34]) by postgresql.org (Postfix) with ESMTP id 716E89DC9DF for ; Mon, 20 Mar 2006 07:02:12 -0400 (AST) Received: from [217.26.17.26] (helo=[10.0.0.72]) by moon.antora.ru with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.60 (FreeBSD)) (envelope-from ) id 1FLI9O-000F62-FV; Mon, 20 Mar 2006 14:02:14 +0300 Message-ID: <441E8B1F.60004@bankir.ru> Date: Mon, 20 Mar 2006 13:59:43 +0300 From: "Eugene E." User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050517) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Peter Eisentraut CC: pgsql-sql@postgresql.org, PFC Subject: Re: have you feel anything when you read this ? References: <002701c64be1$de30c220$1e21100a@ghwk02002147> <200603200950.01126.peter_e@gmx.net> <441E6E78.7030709@bankir.ru> <200603201147.06183.peter_e@gmx.net> In-Reply-To: <200603201147.06183.peter_e@gmx.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/291 X-Sequence-Number: 24637 Peter Eisentraut wrote: > Eugene E. wrote: > >>you may decide to print something else, aint'you ? >>BUT >>if they print them then they at least OUTPUT them. > > > I'm not sure what you are getting at here. The only data type in > PostgreSQL that has a notion of null bytes is bytea, and bytea prints > out null bytes in unambigious form. the bytea does not output NULs at all. don't mock me. > Note that printing out a space > will lose the null byte on restore, ok, if you or they or me miscall OUTPUT "the printing" then "print" NUL-byte itself to preserve it on restore.