Re: array_agg and libpq(xx)

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: array_agg and libpq(xx)
Date: 2009-03-19 22:28:38
Message-ID: 2f4958ff0903191528i46ad4bcld6ae422e2a6b2f6d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/3/19 John R Pierce <pierce(at)hogranch(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-03-19 22:28:57 Re: Is there a meaningful benchmark?
Previous Message Michael Higgins 2009-03-19 22:28:35 Re: Special charaters