On Nov 6, 2012, at 1:34 PM, Tim Landscheidt <t...@tim-landscheidt.de> 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