From: Michael Fuhr <mike@fuhr.org>
To: ::Willi the One:: <sonic_and_tails2000@yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Retrieving timestamp data
Date: Sun, 4 Mar 2007 12:17:18 -0700
Message-ID: <20070304191718.GA39524@winnie.fuhr.org> (raw)
In-Reply-To: <20070304175459.82626.qmail@web36710.mail.mud.yahoo.com>
References: <20070304172355.GA38897@winnie.fuhr.org>
<20070304175459.82626.qmail@web36710.mail.mud.yahoo.com>
On Sun, Mar 04, 2007 at 09:54:59AM -0800, ::Willi the One:: wrote:
> > Unless you request results in binary format all values will be
> > returned as text strings. What happened when you tried it? Are
> > you requesting results in binary format?
>
> So all data are returned as string unless I say so?
PQexecParams() and PQexecPrepared() take an argument that specifies
the result format so you have to indicate which format you want.
PQexec() doesn't take a format argument so it returns results in
text format unless you're fetching from a binary cursor.
> by the way, are there any site containing tutorials on
> libpq?
Probably; Google is your friend :-)
--
Michael Fuhr
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: mike@fuhr.org, sonic_and_tails2000@yahoo.com
Subject: Re: Retrieving timestamp data
In-Reply-To: <20070304191718.GA39524@winnie.fuhr.org>
* 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