The advantage of this approach is that you can put a useful index on
integerPower and that might speed up your queries.
This *is* an enormous advantage, but I dont think I want to go down
this route because I would potentially have to perform some database
maintenance every time I want to insert any records.
Hi Jazz,
I don't think you have to perform any database maintenance at INSERT
time. The generated column will automatically do the maintenance for you.
Ahhh, I think I misunderstood what you were originally suggesting.
Yes, that seems like good approach.
I can use the function that Sylvain provided as the CASTing function.
Thanks again everyone.
Regards,
Jazz
