Re: libpq support for arrays and composites - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: libpq support for arrays and composites
Date
Msg-id 484CB23D.8010706@dunslane.net
Whole thread Raw
In response to Re: libpq support for arrays and composites  (Andrew Chernow <ac@esilo.com>)
Responses Re: libpq support for arrays and composites
Re: libpq support for arrays and composites
List pgsql-hackers

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
andgotten 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






pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: handling TOAST tables in autovacuum
Next
From: Tom Lane
Date:
Subject: Re: libpq support for arrays and composites