> <ohp@pyrenet.fr <mailto:ohp@pyrenet.fr>> wrote: > > > On Thu, 29 Nov 2007, Gregory Stark wrote: > > > > > What do you want the resulting bytea to look like? > > > > > example : id = 9 , bytea = '\000\000\011' IIRC > > What do you expect to happen when server and client are > differently-endian? > > -Doug >
Usama Dar írta:
> Does it matter if you have written an explicit cast for int to bytea? >
You don't know what't endianness is, do you? Say, you have a number: 0x12345678. This is stored differently depending on the endianness.
So, how do you want your number to come out as a byte array? Since a bytea is a sequence of bytes as stored in memory, you may have different meaning for an int->bytea conversion.
It's your homework to look up what's "network order" is. :-) But it would give you consistent answer no matter what CPU your server uses.
1) i wasn't aware people are sensitive to top email reply vs inline, apologies if it offended you
2) i know what a byte order is , i just thought your interface i.e. libpq would convert it to the local byte order.
-- ---------------------------------- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH http://www.postgresql.at/