Re: Retrieving points, arrays, ... with libpq

From: Jeroen Vermeulen <jtv(at)xs4all(dot)nl>
To: Georges(dot)Brefort(at)sanofi-aventis(dot)com
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Retrieving points, arrays, ... with libpq
Date: 2008-10-22 05:27:28
Message-ID: 48FEB9C0.7030608@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Georges(dot)Brefort(at)sanofi-aventis(dot)com wrote:

> I have read the most recent documentation from the first to the very
> last line, and I guess I can retreive data of any type with the
> PQgetValue() function, something like:
>
> char* chunkOfMemory = PQgetvalue( (const PGresult*) myresult,
> row_number, column_number);
>
> But then, is it possible to cast the char* pointer to some meaningfull C
> structure if column_number relates to some datatype other than text or
> integer ?

By default, you get your data in a textual representation. So you need
to parse the string that that char* points to. (It's also possible to
work in binary mode, but then you've got a lot more worries about
portability and such for not much gain in speed.)

Jeroen

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Joe Halpin 2008-10-28 19:34:41 Problem with trigger function in C
Previous Message Georges.Brefort 2008-10-20 15:06:25 Retrieving points, arrays, ... with libpq