Re: Retrieving timestamp data

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "::Willi the One::" <sonic_and_tails2000(at)yahoo(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Retrieving timestamp data
Date: 2007-03-04 19:17:18
Message-ID: 20070304191718.GA39524@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message makhan 2007-03-06 09:56:41 Interfacing to postgresql running on an embedded processor
Previous Message Tom Lane 2007-03-04 18:39:31 Re: Multikey Index GISt