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

From Merlin Moncure
Subject Re: array_agg and libpq(xx)
Date
Msg-id b42b73150903191749v5971c9c1qd25f292756ebc323@mail.gmail.com
Whole thread Raw
In response to Re: array_agg and libpq(xx)  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
2009/3/19 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
> 2009/3/19 Merlin Moncure <mmoncure@gmail.com>:
>
>> if you are moving arrays (and/or composites) into out of database
>> through libpq, check out libpqtypes:
>>
>> http://libpqtypes.esilo.com/
>
> Thanks, I will have to do it via libpqxx unfortunately. Which
> complicates matter a bit, since they don't expose libpq. (which for
> instance sux, because there's no equivalent of execParam() in pqxx,
> and prepared statements aren't always what I am aiming for..).

I see.  well, libpqxx is just a wrapper to libpq, same as libpqtypes.
Barring that, your best bet is to parse the string or unnest the array
in the query.

merlin

pgsql-general by date:

Previous
From: John Cheng
Date:
Subject: Re: Is there a meaningful benchmark?
Next
From: Greg Williamson
Date:
Subject: Re: Is there a meaningful benchmark?