Perl hashref and DBI

[Collins Richey]

On Mon, Mar 7, 2011 at 8: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.
>

Try two.

One-time overhead to alter the table to include the desired values as
an additional column or create a permanent linkage table with the real
and desired keys. Obviously slight modification of any existing logic.



-- 
Collins Richey
     If you fill your heart with regrets of yesterday and the worries
     of tomorrow, you have no today to be thankful for.