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 B7C5B11F68D8 for ; Tue, 4 Apr 2006 07:33:28 -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 93795-03 for ; Tue, 4 Apr 2006 07:33:28 -0300 (ADT) 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 667E711F6557 for ; Tue, 4 Apr 2006 07:33:25 -0300 (ADT) 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 1FQiqc-000Eey-0N; Tue, 04 Apr 2006 14:33:18 +0400 Message-ID: <44324AB6.2060104@bankir.ru> Date: Tue, 04 Apr 2006 14:30:14 +0400 From: "Eugene E." User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050517) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Stephan Szabo CC: Peter Eisentraut , Achilleus Mantzios , pgsql-sql@postgresql.org Subject: Re: have you feel anything when you read this ? References: <441EA0A7.8030601@bankir.ru> <200603201415.30719.peter_e@gmx.net> <442CC95C.1030700@bankir.ru> <20060331084503.W64402@megazone.bigpanda.com> In-Reply-To: <20060331084503.W64402@megazone.bigpanda.com> Content-Type: text/plain; charset=ISO-8859-1; 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: 200604/11 X-Sequence-Number: 24820 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" ?