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 234D211F65DB for ; Tue, 4 Apr 2006 11:21:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33666-02 for ; Tue, 4 Apr 2006 11:21:24 -0300 (ADT) 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 A344811F65FF for ; Tue, 4 Apr 2006 11:21:21 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id A4E4534D5B; Tue, 4 Apr 2006 07:21:21 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id A282534D58; Tue, 4 Apr 2006 07:21:21 -0700 (PDT) Date: Tue, 4 Apr 2006 07:21:21 -0700 (PDT) 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: <44324AB6.2060104@bankir.ru> Message-ID: <20060404071118.C19036@megazone.bigpanda.com> References: <441EA0A7.8030601@bankir.ru> <200603201415.30719.peter_e@gmx.net> <442CC95C.1030700@bankir.ru> <20060331084503.W64402@megazone.bigpanda.com> <44324AB6.2060104@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.137 required=5 tests=[AWL=0.137] X-Spam-Score: 0.137 X-Spam-Level: X-Archive-Number: 200604/13 X-Sequence-Number: 24822 On Tue, 4 Apr 2006, Eugene E. wrote: > Stephan Szabo wrote: > > 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. > > Documentation says: > === > PQexecParams > > Submits a command to the server and waits for the result, with the > ability to pass parameters separately from the SQL command text. > === > > How should i use this func to change so-called "textual form" of a > select-result to so-called "binary form" ?