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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq