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 B54B99DCD5F for ; Mon, 20 Mar 2006 09:15:34 -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 76107-03 for ; Mon, 20 Mar 2006 09:15:34 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 037779DCC2E for ; Mon, 20 Mar 2006 09:15:28 -0400 (AST) Received: (qmail invoked by alias); 20 Mar 2006 13:15:32 -0000 Received: from dslb-084-063-042-173.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.42.173] by mail.gmx.net (mp020) with SMTP; 20 Mar 2006 14:15:32 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: "Eugene E." Subject: Re: have you feel anything when you read this ? Date: Mon, 20 Mar 2006 14:15:29 +0100 User-Agent: KMail/1.8.3 Cc: Achilleus Mantzios , pgsql-sql@postgresql.org References: <441EA0A7.8030601@bankir.ru> In-Reply-To: <441EA0A7.8030601@bankir.ru> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-7" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200603201415.30719.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.131 required=5 tests=[AWL=0.131] X-Spam-Score: 0.131 X-Spam-Level: X-Archive-Number: 200603/303 X-Sequence-Number: 24649 Eugene E. wrote: > the problem is: you'll get this four byte sequence '\000' _instead_ > of NUL-byte anyway. What you seem to be missing is that PostgreSQL data can be represented in textual and in binary form. What you in psql is the textual form. If you want the binary form you need to select it. Then you can pass the exact bytes back and forth. -- Peter Eisentraut http://developer.postgresql.org/~petere/