Re: convert int to bytea

[Andrew Dunstan <andrew(at)dunslane(dot)net>]

Usama Dar wrote:
> 2) i know what a byte order is , i just thought your interface i.e. 
> libpq would convert it to the local byte  order.

You haven't thought this through. Data traveling over libpq is still 
text, not binary, in most cases, so byte order is irrelevant at that 
time. The translation to a bytea (if possible) would be done after the 
data was already on the server and the int was in its native, 
architecture dependent form.

The short answer is thus still that there is no sane consistent cast 
from int to bytea.

If you want a bytea then it's really up to you to contruct the byte array.

cheers

andrew