On Tue, Mar 16, 2021 at 1:31 PM Ruslan <ruslan@xxxxxxxxxxxx> wrote: > > 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 > > https://github.com/postgres/postgres/blob/REL_13_STABLE/src/backend/utils/adt/date.c#L2150-L2159 > > 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. Check out libpqtypes -- it has client side send/receive functions for binary format you can crib from. https://github.com/pgagarinov/libpqtypes/blob/master/source/src/datetime.c merlin
