Doug,

Thanks you for your answers.

The way you pull SQL data out of the database is exactly what I was
looking for. A single statement that loads the whole array into a
piddle - perfect!


On Wed, Sep 30, 2009 at 8:57 PM, Doug Hunt <[email protected]> wrote:

> use DBI;
> use PDL;
> my $dbstr = "dbi:Pg:dbname=$dbname;host=$dbhost";
> my $dbh   = DBI->connect($dbstr);
> my $sql   = 'select yr, mon, day, value from db_table where yr=2007';
> my $data  = pdl($dbh->selectall_arrayref($sql));
>
> Now $data is a 4 x N PDL (which defaults to type 'double').
>

_______________________________________________
Perldl mailing list
[email protected]
http://mailman.jach.hawaii.edu/mailman/listinfo/perldl

Reply via email to