Perl hashref and DBI

[Andrew Gould]

On Mon, Mar 7, 2011 at 9:29 PM, David A. Bandel <david.bandel at gmail.com> wrote:
> On Mon, Mar 7, 2011 at 18:27, Collins Richey <crichey at gmail.com> wrote:
>> Maybe I'm missing something.
>>
>> Sounds like a match for a temporary table. Retrieve the data, massage
>> the keys, create a temporary table using the new keys. Then you can
>> use all the usual query magic to process the data.
>
> yep -- exactly the overhead I was hoping to avoid.
>
>>
>> --
>> Collins Richey
>>      If you fill your heart with regrets of yesterday and the worries
>>      of tomorrow, you have no today to be thankful for.
>>
>> _______________________________________________
>> Linux-users mailing list ( Linux-users at linux-sxs.org )
>> Unsub/Password/Etc:
>> http://linux-sxs.org/mailman/listinfo/linux-users
>>
>> Need to chat further on this subject? Check out #linux-users on irc.linux-sxs.org !
>>
>
>
> David A. Bandel
> --
> Focus on the dream, not the competition.
>             - Nemesis Air Racing Team motto
> Visit my web page at: http://david.bandel.us/
>
> _______________________________________________
> Linux-users mailing list ( Linux-users at linux-sxs.org )
> Unsub/Password/Etc:
> http://linux-sxs.org/mailman/listinfo/linux-users
>
> Need to chat further on this subject? Check out #linux-users on irc.linux-sxs.org !
>

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