Re: have you feel anything when you read this ?

From: "Eugene E(dot)" <sad(at)bankir(dot)ru>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: have you feel anything when you read this ?
Date: 2006-04-04 10:30:14
Message-ID: 44324AB6.2060104@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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" ?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2006-04-04 11:05:41 Re: have you feel anything when you read this ?
Previous Message Vellinga, Fred 2006-04-04 08:40:12 Special meaning of NL string