Re: Retrieving timestamp data - Mailing list pgsql-interfaces

From Michael Fuhr
Subject Re: Retrieving timestamp data
Date
Msg-id 20070304191718.GA39524@winnie.fuhr.org
Whole thread Raw
In response to Re: Retrieving timestamp data  ("::Willi the One::" <sonic_and_tails2000@yahoo.com>)
List 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


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multikey Index GISt
Next
From: MicazMAK
Date:
Subject: Interfacing postgresql running on an embedded processor