Hi folks,
Apologies if it's the wrong place to ask. I have a question for postgres developers.
I wrote parser for COPY binary encoding. Everything is great but one thing worries me. It seems like the time offset field has reversed digit sign. I'm referring to this function
COPY response for value '13:37:00-0300'::timetz gives me binary 0x0000000b69d1d70000002a30. And value '13:37:00+0300'::timetz is encoded as 0x0000000b69d1d700ffffd5d0.
0xffffd5d0 is -10800 for signed integer and 0x00002a30 is 10800.
I reverse the sign in my code but feeling that I'm missing something is nagging me. Please advise.