Re: how can i get the binary format of timestamp? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: how can i get the binary format of timestamp?
Date
Msg-id 26113.1145458371@sss.pgh.pa.us
Whole thread Raw
In response to Re: how can i get the binary format of timestamp?  ("energumen@buaa.edu.cn" <energumen@buaa.edu.cn>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: concurrent transactions inside the same connection
Next
From: John DeSoi
Date:
Subject: Re: Google SoC--Idea Request