On Wed, Sep 2, 2009 at 3:50 PM, Dave
Huber<dhu...@letourneautechnologies.com> wrote:
> I have an old table with a column specified as integer[]. The data within
> this column was stored as text ala {1,2,3,…} yada yada. I have an
> application where I am reading all the columns from a row in this table in
> binary format. Does anybody know how I can recast/reshape this binary data
> back into an array of integers?check out our libpqtypes library: http://libpqtypes.esilo.com/ It pulls all data as binary and allows you to access array elements, and you can write data the same way. PostgreSQL binary formats are more complicated than you think: there is dimension information, etc. in there. (that said, sending int[] as binary is much faster). merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
