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 71BA09DC97D for ; Tue, 21 Mar 2006 06:36:01 -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 33917-04 for ; Tue, 21 Mar 2006 06:36:03 -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 346769DC8DB for ; Tue, 21 Mar 2006 06:35:58 -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 1FLeDW-000ISm-5K; Tue, 21 Mar 2006 13:35:58 +0300 Message-ID: <441FD675.9040308@bankir.ru> Date: Tue, 21 Mar 2006 13:33:25 +0300 From: "Eugene E." User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050517) X-Accept-Language: en-us, en MIME-Version: 1.0 To: PFC CC: Achilleus Mantzios , Peter Eisentraut , pgsql-sql@postgresql.org Subject: Re: have you feel anything when you read this ? References: <441EA0A7.8030601@bankir.ru> <441EC1CC.4070300@bankir.ru> In-Reply-To: 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/324 X-Sequence-Number: 24670 PFC wrote: > >> I wrote: >> >>>> the problem is: you'll get this four byte sequence '\000' _instead_ >>>> of NUL-byte anyway. >> >> >> You wrote: >> >>> Your client library should take care of escaping and de-escaping. >> >> >> We both agree as you see. >> >> Then i am asking: >> WHY should a client take care of de-escaping ? Why not to get his >> data unchanged ? > > > I can understand why you say that for something as simple as a > BYTEA, but if the value to be passed to the client is an ARRAY of > geometric types or something Who said "array" ? I just want to restore _one byte_ from bytea storage. that's all. > Exporting data from postgres in binary is only useful to C > programmers Serious judgment ! Extremely seriuos... nonetheless C programmers could not do this.