be extremely careful with this approach, as it actually caches your result set in memory. if you're querying against 400 GB of data, you might not want that entire resultset stored locally ;)
revision uno: hmm, that's a selectcol_arrayref which only caches the first column's values IIRC (which still might be relatively large), not selectall_arrayref which caches the entire resultset