John DeSoi wrote:
I'd like to convert some bytea data to an array of four byte integers
(and vice versa). I'm probably missing something obvious, but I don't
see an efficient way to generate a 4 byte integer from a bytea string
(could be big endian or little endian).
get_byte()?
mailtest=> \set e '\'\12\15\107\20\'::bytea'
mailtest=> select
get_byte(:e,0),get_byte(:e,1),get_byte(:e,2),get_byte(:e,3);
get_byte | get_byte | get_byte | get_byte
----------+----------+----------+----------
10 | 13 | 71 | 16
(1 row)
Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
