[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,

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

2009-03-23 Thread Tom Lane
Whit Armstrong armstrong.w...@gmail.com 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

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 t...@sss.pgh.pa.us wrote: Whit Armstrong armstrong.w...@gmail.com writes: but it is still unclear (at least to me) how to determine as the client whether the server has been compiled with the