Re: [HACKERS] Unstable timestamp binary representation?

2005-03-18 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh <[EMAIL PROTECTED]> writes: In other words, it seems that I, as a client, needs to guess whether postgres was compiled with or without "HAVE_INT64_TIMESTAMP". No, you need to inquire of the value of the "integer_datetimes" parameter. (At least as of 8.0, th

Re: [HACKERS] Unstable timestamp binary representation?

2005-03-18 Thread Tom Lane
Shachar Shemesh <[EMAIL PROTECTED]> writes: > In other words, it seems that I, as a client, needs to guess whether > postgres was compiled with or without "HAVE_INT64_TIMESTAMP". No, you need to inquire of the value of the "integer_datetimes" parameter. (At least as of 8.0, this is provided "for

[HACKERS] Unstable timestamp binary representation?

2005-03-18 Thread Shachar Shemesh
Hi all, In the OLE DB code there is code for parsing timestamps received from the server. This code behaves erratically. Upon further examination, I found the following piece of code in Postgresql's "timestamp2tm": #ifdef HAVE_INT64_TIMESTAMP dt -= CTimeZone * INT64CONST(100); #else