Sunday, June 8, 2008

Re: [HACKERS] libpq support for arrays and composites

Andrew Chernow wrote:
>
> libpqtypes already implemented this. It is a different approach but
> provides the same functionality; with the inclusion of being able to
> handle every data type. libpqtypes uses the PGresult API for
> composites and arrays, rather than adding a new set of functions.
>
>

Yes, I thought you'd say that :-)

This has some significant limitations - for example (quoting from your docs)

Arrays are only handled using binary format. This means that any type
used as an array element must be put and gotten in binary format. If a
user-defined type does not implement a send and recv function in the
backend, it can not be used as an array element.

That makes it quite useless for my intended purpose.

I also am not particularly enamoured of the libpqtypes way of doing things, which feels rather foreign to me.

Lastly, the idea is to provide extra facilities to libpq clients without requiring any extra library.

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

No comments: