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

From: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: libpq -- reading a timestamp with time zone using binary format
Date: 2009-03-23 23:25:30
Message-ID: 8ec76080903231625jf4d780s77bf0cf88ddbbb07@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks, Tom.

That's just what I needed.

-Whit

On Mon, Mar 23, 2009 at 7:15 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Whit Armstrong <armstrong(dot)whit(at)gmail(dot)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 client it's sufficient to use
> PQparameterStatus(), because this value is sent automatically
> during connection startup.
>
>                        regards, tom lane
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-03-23 23:26:59 Re: 1- and 2-dimensional indexes on same column: why is the 2d one preferred?
Previous Message Tom Lane 2009-03-23 23:15:33 Re: libpq -- reading a timestamp with time zone using binary format