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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
