| 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: | Whole Thread | Raw Message | 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
| 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 |