Re: Retrieving points, arrays, ... with libpq - Mailing list pgsql-interfaces

From Jeroen Vermeulen
Subject Re: Retrieving points, arrays, ... with libpq
Date
Msg-id 48FEB9C0.7030608@xs4all.nl
Whole thread Raw
In response to Retrieving points, arrays, ... with libpq  (<Georges.Brefort@sanofi-aventis.com>)
List pgsql-interfaces
Georges.Brefort@sanofi-aventis.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


pgsql-interfaces by date:

Previous
From:
Date:
Subject: Retrieving points, arrays, ... with libpq
Next
From: "Joe Halpin"
Date:
Subject: Problem with trigger function in C