Hi,

I use "LibPQ.dll" to connect a Posgres Database With Delphi 2009.

Did anyone knows how to get a variant representation of query fields ?

All results of queries are pAnsiChar, for example "select 2+2" returns a
pAnsiString "4"

Thanks,

David

davidcfres wrote:
Is Delphi linked with libpq or is there something else
in between (ODBC driver, ...)?

PostgreSQL lets you specify whether you want your query
results sent to the client in string or its internal
binary format.
String is preferred for portability reasons.

It is the responsibility of the code using libpq to convert
the textual representation to any other (client) data type.

So perhaps the PostgreSQL support of Delphi or the connector
it uses is not smart enough to do this correctly.

Yours,
Laurenz Albe