PFC wrote:
>
>> I wrote:
>>
>>>> the problem is: you'll get this four byte sequence '\000' _instead_
>>>> of NUL-byte anyway.
>>
>>
>> You wrote:
>>
>>> Your client library should take care of escaping and de-escaping.
>>
>>
>> We both agree as you see.
>>
>> Then i am asking:
>> WHY should a client take care of de-escaping ? Why not to get his
>> data unchanged ?
>
>
> I can understand why you say that for something as simple as a
> BYTEA, but if the value to be passed to the client is an ARRAY of
> geometric types or something
Who said "array" ? I just want to restore _one byte_ from bytea storage.
that's all.
> Exporting data from postgres in binary is only useful to C
> programmers
Serious judgment ! Extremely seriuos...
nonetheless C programmers could not do this.