Re: array_agg and libpq(xx) - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: array_agg and libpq(xx)
Date
Msg-id 2f4958ff0903191528i46ad4bcld6ae422e2a6b2f6d@mail.gmail.com
Whole thread Raw
In response to Re: array_agg and libpq(xx)  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
2009/3/19 John R Pierce <pierce@hogranch.com>:
>   pgResult = PQexec(pgConn, "select array['123','456','abc','def'];");
>   pgarray = PQgetvalue(pgResult,0,0);
>
> will return a pointer to the ARRAY in postgres format as defined by the
> typsend/recieve internal functions for the ARRAY type.   you would need to
> walk this and copy the strings comprising the array to your own managed
> storage (malloc, or whatever) prior to calling PQclear(pgResult).   I'm
> trying to find the docs on what the typsend format for ARRAY looks like and
> failing.

Clearly looking like libpqq(xx) are missing that functionality built
in to protocol/api...



--
GJ

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: array_agg and libpq(xx)
Next
From: Scott Marlowe
Date:
Subject: Re: Is there a meaningful benchmark?