From: Jakob Lechner <jakob.lechner@applstrudl.com>
To: Michael Meskes <meskes@postgresql.org>
Cc: Wilhansen Li <willi.t1@gmail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Timestamp with libpq
Date: Mon, 13 Oct 2008 17:43:50 +0200
Message-ID: <1223912631.3502.79.camel@vie063.fabagl.fabasoft.com> (raw)
In-Reply-To: <20081013125929.GA23953@feivel.credativ.de>
References: <1223884381.3502.10.camel@vie063.fabagl.fabasoft.com>
<bc9549a50810130232nf40bfd2l2aee3c8c3ff5ec7e@mail.gmail.com>
<1223891843.3502.33.camel@vie063.fabagl.fabasoft.com>
<20081013104627.GA23971@feivel.credativ.de>
<1223901242.3502.54.camel@vie063.fabagl.fabasoft.com>
<20081013125929.GA23953@feivel.credativ.de>
Hi,
Am Montag, den 13.10.2008, 14:59 +0200 schrieb Michael Meskes:
>
> I doubt this. It might be true for double storage but not for 8 byte integers,
> well that is in the database of course. But I see no reason whatsoever that the
> data is truncated by libpq.
>
I found an easy solution for my problem: Libpq provides information if
the timestamps are double values or integer values.
When passing the parameter "integer_datetimes" to the function "PQparameterStatus"
"on" or "off" is returned.
I adapted my conversion routine to handle both integer and double
timestamps. Everything works fine now.
Best regards
Jakob
--
Jakob Lechner
Research & Development
appl.strudl Software GmbH
Honauerstraße 4
A-4020 Linz
Tel.: [+43] (70) 60 61 62
Fax: [+43] (70) 60 61 62-609
E-Mail: jakob.lechner@applstrudl.com
Web: http://www.applstrudl.com
Handelsgericht Linz, FN 303988 t
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jakob.lechner@applstrudl.com, meskes@postgresql.org, willi.t1@gmail.com
Subject: Re: Timestamp with libpq
In-Reply-To: <1223912631.3502.79.camel@vie063.fabagl.fabasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox