Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group