db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jasvinder S. Bahra" <bbdl21...@blueyonder.co.uk>
Subject Re: Converting a value held in a VARCHAR column into an INTEGER
Date Fri, 12 Mar 2010 14:32:09 GMT
>>> 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.



View raw message