Re: converting from bytea to integers

	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