Concat integers as binary strings to bytea

Question

is it possible in PostgreSQL 8.4 to concat multiple integers (int4) values to a bytea value?

For example:

5::int4 || 1::int4

should result in a bytea value with (0x05 0x00 0x00 0x00 0x01 0x00 0x00 0x00), assuming a little endian machine.

araqnid · Accepted Answer · 2012-01-12 20:59:25Z

2

Well, int4send will convert an int4 to a bytea, but I suspect from the name it will always use network ordering.

that is:

steve@steve@[local] =# select int4send(3);
  int4send  
------------
 \x00000003

event on an amd64 machine.

answered Jan 12, 2012 at 20:59

araqnid

135k25 gold badges164 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vérace Feb 15 at 23:30

You might mention that the *send() functions are (still) undocumented!

Augustus Kling · Accepted Answer · 2012-01-12 21:13:04Z

1

An indirect conversion can be made with select byteain(bit_out(5::bit(32) || 1::bit(32))) or select int4send(5)||int4send(1) which results in 0000000000000000000000000000010100000000000000000000000000000001.

You could also use binary string functions to convert to your desired encoding. See Maarten Foqué's answer on the pgsql-general list for a solution to a similar problem. You should be able to simple concatenate the resulting bytea values from his function or a similar function (but mark it as stable instead of volatile).

answered Jan 12, 2012 at 21:13

Augustus Kling

3,3331 gold badge24 silver badges25 bronze badges

Collectives™ on Stack Overflow

Concat integers as binary strings to bytea

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related