Re: Array elements (urgent help needed)

Akbar Mokhtarani <akbarm(at)slac(dot)stanford(dot)edu> writes:

* A standard varlena array has the following internal structure:

This didn't quite agree with what I found but it gave me a starting point.

That's because it's describing the *internal* structure. Since you're
on 7.4, what you are actually seeing is the on-the-wire representation
emitted by array_send(), which looks like:

/* Send the array header information */
pq_sendint(&buf, ndim, 4);
pq_sendint(&buf, v->flags, 4);
pq_sendint(&buf, element_type, sizeof(Oid));
for (i = 0; i < ndim; i++)
{
pq_sendint(&buf, ARR_DIMS(v)[i], 4);
pq_sendint(&buf, ARR_LBOUND(v)[i], 4);
}

/* Send the array elements using the element's own sendproc */
/* (so N element values in whatever the datatype format is) */

regards, tom lane