Re: [GENERAL] Dumb question about binary cursors and #ifdefHAVE_INT64_TIMESTAMP

> -----Original Message-----
> From: Alvaro Herrera [mailto:alvherre@alvh.no-ip.org]
> Sent: Tuesday, December 11, 2007 1:11 PM
> To: Dann Corbit
> Cc: pgsql-hackers@postgresql.org; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Dumb question about binary cursors and
> #ifdefHAVE_INT64_TIMESTAMP
>
> Dann Corbit wrote:
> > If I create a binary cursor on a recent version of PostgreSQL, how
can I
> > tell if the timestamp data internally is an 8 byte double or an 8
byte
> > integer?
> >
> > I see an #ifdef that changes the code path to compute timestamps as
one
> > type or the other, but I do not know how to recognize the internal
> > format of the type that will be returned in a binary cursor.
> >
> > How can I do that?
>
> SHOW integer_timestamp;
>
> (actually, IIRC, this is one of the params that the server will send
you
> at session start).

Tom's post clued me in.
It's:
show integer_datetimes;

Or (in my case):
PQparameterStatus(conn, "integer_datetimes")