Re: How to pass ad-hoc "complex" data structures?

On Nov 6, 2012, at 1:34 PM, Tim Landscheidt <[email protected]> wrote:

> I should have pointed out more clearer the problem :-).  The
> query itself is fine; tmpData in this case is probably mis-
> named as it is really meant to represent the (permanent)
> data in PostgreSQL.
> 
> The question is how to pass the data structure:
> 
> | my @Data = ([1, 'Z'], [4, 'E'], [7, 'L']);
> 
> from the Perl side via DBD::Pg to use it for comparison (or
> whatever) in PostgreSQL.

You could pass it as a nested text array. I'd love to see hashes abled to be passed as RECORDs.

Best,

David