Re: DBI / DBD and array data types

On Tue, Dec 30, 2008 at 01:56:34PM -0500, Hildo Biersma wrote:
> I'm talking about a different feature, where a single parameter to a stored 
> procedure, which will be executed a single time, is given a variable-sized 
> array of values (i.e. an array datatype).  An example would be a stored 
> procedure with a signature like
>
>   CREATE PROCEDURE inArray (IN input IntArray)
>
> I think PostgreSQL supports the same feature, but I may be wrong.

It does: http://search.cpan.org/~turnstep/DBD-Pg/Pg.pm#Array_support

(It's handled by the driver converting the array to/from a string
representation - but that's just an implementation detail.)

Tim.