Teunis Peters <teunis(at)wintersgift(dot)com> writes:
> I'm trying to figure out how to read from and write to bytea values and
> array (specifically "text" for a key:value 'dictionary') and
> cannot figure it out.
Well, since you are asking for binary output format from PQexecParams,
the bytea result is going to just be raw binary data: you should not be
trying to apply PQunescapeBytea to it. I don't know the notation you
are using well enough to tell what's wrong with your second variant.
> Arrays I'm completely lost - I haven't a clue what the format would be.
Looking at array_send, the binary wire format is
number of dimensions (int4)
element type id (Oid)
for each dimension:
dimension length (int4)
dimension lower subscript bound (int4)
for each array element:
element value, in the appropriate format
The "flags" are currently always 0, and I would recommend punting if
you see something else, since something else would very possibly
indicate a change in the wire format.
Don't forget that the wire format for integers is network byte order
regards, tom lane
In response to
pgsql-interfaces by date
|Next:||From: Volkan YAZICI||Date: 2005-05-16 10:12:37|
|Subject: Network Byte Order Coercion|
|Previous:||From: Teunis Peters||Date: 2005-05-14 18:40:10|
|Subject: Two seperate problems with libpq - arrays and bytea edit|