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 10E9611F6623 for ; Fri, 31 Mar 2006 12:47:50 -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 63719-02 for ; Fri, 31 Mar 2006 12:47:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by postgresql.org (Postfix) with ESMTP id 76B1F11F660F for ; Fri, 31 Mar 2006 12:47:47 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id A7B5A3515A; Fri, 31 Mar 2006 08:47:46 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id A5A283514F; Fri, 31 Mar 2006 08:47:46 -0800 (PST) Date: Fri, 31 Mar 2006 08:47:46 -0800 (PST) From: Stephan Szabo To: "Eugene E." Cc: Peter Eisentraut , Achilleus Mantzios , pgsql-sql@postgresql.org Subject: Re: have you feel anything when you read this ? In-Reply-To: <442CC95C.1030700@bankir.ru> Message-ID: <20060331084503.W64402@megazone.bigpanda.com> References: <441EA0A7.8030601@bankir.ru> <200603201415.30719.peter_e@gmx.net> <442CC95C.1030700@bankir.ru> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.138 required=5 tests=[AWL=0.138] X-Spam-Score: 0.138 X-Spam-Level: X-Archive-Number: 200603/463 X-Sequence-Number: 24809 On Fri, 31 Mar 2006, Eugene E. wrote: > Peter Eisentraut wrote: > > 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. > > your sentence is not true. > I can not select exact bytes even if i use BYTEA type No, that is still using the textual form. If you use PQexecParams and set the last argument to show you want binary data, you should get binary data.