Perl hashref and DBI

[David A. Bandel]

On Tue, Mar 8, 2011 at 08:31, Andrew Gould <andrewlylegould at gmail.com> wrote:
[snip]
>
> David,
>
> Were you able to pass the query to PostgreSQL?  (something like the following)
>
> select substr(hex_channel_id,5,3) as extension, count(hex_channel_id)
> as frequency
> from table t1
> group by substr(hex_channel_id,5,3)
> order by substr(hex_channel_id,5,3);
>
> Andrew
>

I was able to solve it, but in a slightly different manner.  I just
created another array that contained the substring of the first array.
 Not optimal, but it works.

Ciao,

David A. Bandel
-- 
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto
Visit my web page at: http://david.bandel.us/