Re: how can i get the binary format of timestamp?

"energumen@buaa.edu.cn" <energumen@buaa.edu.cn> writes:
> if define HAVE_INT64_TIMESTAMP
> result is:  4E66 E642 0030 C274
> if not define HAVE_INT64_TIMESTAMP
> {
>   if define INT64_IS_BUSTED result is: 6972 2142 0000 00DB
>   if not define INT64_IS_BUSTED result is: 4221 7269 DB00 0000
> }

I think you got your cases mixed up.  In the not-HAVE_INT64_TIMESTAMP
case the value would be a float8 and wouldn't be affected at all by
INT64_IS_BUSTED.

Defining both HAVE_INT64_TIMESTAMP and INT64_IS_BUSTED is not supported.
        regards, tom lane