Re: [GENERAL] libpq -- reading a timestamp with time zone using binary format

2009-03-23 Thread Whit Armstrong
Thanks, Tom. That's just what I needed. -Whit On Mon, Mar 23, 2009 at 7:15 PM, Tom Lane wrote: > Whit Armstrong writes: >> but it is still unclear (at least to me) how to determine as the >> client whether the server has been compiled with the >> HAVE_INT64_TIMESTAMP flag. > > You look at the

Re: [GENERAL] libpq -- reading a timestamp with time zone using binary format

2009-03-23 Thread Tom Lane
Whit Armstrong writes: > but it is still unclear (at least to me) how to determine as the > client whether the server has been compiled with the > HAVE_INT64_TIMESTAMP flag. You look at the integer_datetimes parameter. You could execute a SQL "SHOW" command, but in a libpq client it's sufficient

[GENERAL] libpq -- reading a timestamp with time zone using binary format

2009-03-23 Thread Whit Armstrong
how does one determine whether libpq is sending an int64 or a double? I see all of the #ifdefs in the source: #ifdef HAVE_INT64_TIMESTAMP static int64 time2t(const int hour, const int min, const int sec, const fsec_t fsec); #else static double time2t(const int hour, const int min, const int sec,