Re: How does DBI return an arrayref with key/value pairs?

[hdb]

From http://search.cpan.org/~timb/DBI-1.53/DBI.pm:

You may often want to fetch an array of rows where each row is stored as a hash. That can be done simple using:

my $emps = $dbh->selectall_arrayref(
      "SELECT ename FROM emp ORDER BY ename",
      { Slice => {} }
  );
  foreach my $emp ( @$emps ) {
      print "Employee: $emp->{ename}\n";
  }

So despite the name you get a reference to an array of hash references.

UPDATE: Have you tried looking at it using Data::Dumper? Should show the structure being a hash at the bottom.